This topic is locked
[SOLVED]

 ASP Error number -2147217904

3/2/2005 11:15:52 AM
ASPRunnerPro General questions
author

Hello Sergey -
I am making progress thanks to you. However, here is the latest misstep:
ASP error happened

Technical information

Error number -2147217904

Error description [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect

URL /asprunner/Resume_Data_view.asp

SQL query select [Binary File], [Resume Data], [First Name], [Middle Initital], [Last Name], [Street Address 1], [Street Address 2], [Apartment Number], [City], [State], [Zipcode], [Country], [Telpehone Number], [Want Telephone on Resume?], [Cell Phone Number], [Want Cell Phone on Resume?], [Email Address], [Want Email Address on Resume?], [Position Desired], [Areas of Knowledge and Experience], [Colleges, Degrees, Dates], [Professional Memberships], [Travel], [Willing to Relocate?], [Military Service Rank, Service, Dates], [Honorable Discharge?], [Availability], [Can Employer be Contacted?], [Foreign Languages], [Special Recognition and Awards], [Computer Skills and Training], [Additional Comments] from [Resume Data] where [Last Name]='Hartman' and [Telpehone Number]='631-543-1334' and [Email Address]='shartman@nyit.edu'
I did edit the database and did remove the one count field in it. There are no others. I am bewildered.
Thanks.
Steve Hartman <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1189&image=1&table=forumtopics' class='bbc_emoticon' alt=':angry:' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1189&image=2&table=forumtopics' class='bbc_emoticon' alt=':angry:' />

500199 3/2/2005

Sergey -
One other thing. Are yes/no fields allowed in the database?
Thanks again.
Steve Hartman

Admin 3/3/2005

Steve,
yes/no fields are allowed.
I've found that this error occurs due to the question-mark in the field name.
For more info read this

article