2. ASPRunnerPro General questions
  3. Type MissMatch Error
This topic is locked

Type MissMatch Error

 		4/30/2005 10:17:54 PM
ASPRunnerPro General questions
jmisson author

Hi,
I am stumped. I am using the newest beta version and I am getting the following error:
Error number -2147217913

Error description [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

URL /qryNotes_list.asp

SQL query select [NotesID], [EnquiryFK], [DateNote], [Status], [Comments], [AssignedConsultant] From [qryNotes] where [EnquiryFK] = '51' ORDER BY [NotesID] DESC
The dates do not have Null values. If I remove the where statement i.e. do not designate a Master and Detail table in step 3, the list is displayed, but obviously with no filtering.
EnquiryFK is on type Number if that is any clue.
If someone could give me an idea, that would be great.
Regards
Julie
Sergey Kornilov admin 5/1/2005

Julie,
please zip and send to support@xlinesoft.com the whole content of ASPRunner output folder ( ASP files, include files, database etc.) along with the project file. I'll find what's wrong running it on my test box.
jmisson author 5/7/2005

Sergey,
Many thanks for your reply. Before I sent it to you. I thought I should repackage as I could not remember what changes I had made. I noticed there was a beta version 3, so downloaded that and rebuilt the whole project.
It now works beautifully.
Thanks for your support on this forum. It is one of the things that makes this product so good. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=4307&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />
Cheers
Julie

www.simply-access.com