2. ASPRunnerPro General questions
  3. Data type mismatch in criteria expression.
This topic is locked

Data type mismatch in criteria expression.

 		2/6/2007 08:24:38
ASPRunnerPro General questions
J
 jimw123 author

I get the following error when trying to conduct a search:

Error number -2147217913

Error description [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
The problem occurs when I try to search and include criteria to search on a field that is a checkbox on the edit and add pages. On the search page it is a "True/False" drop down box. The "list" page is shown as the source of the error. The info supplied on the FAQ #5 is not applicable here, since this error only occurs when I include criteria on a field that is enterred with a checkbox.
This error surfaced after upgrading from 4.0 to 4.1.
J
 		Jane 2/6/2007

Please publish your project on Demo Account and send to [email=support@xlinesoft.com]support@xlinesoft.com[/email] a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.
J
 		jimw123 author 2/6/2007

Sorry, but what do you mean publish on demo account?
J
 		jimw123 author 2/6/2007

I see the demo account button and have uploaded the files. Here is a link to the page http://demo.asprunner.net/jwilliams%5Fnull...master_list.asp
This raises another question. Everytime I publish a project, it sets the LCID to 9. I do not see where to change this, so I have been manually changing it to 1033 in \include\dbcommon.asp
On the above link, if you choose criteria only on item 39, and set equal to True, you will get the error I that I originally posted about (of course after changing the LCID)
Sergey Kornilov admin 2/6/2007

Demo Account button can be found on the last tab in ASPRunnerPro.

If you don't have this button download the latest update:

http://www.asprunner.com/forums/index.php?showtopic=4265
J
 		jimw123 author 2/6/2007

I did find the demo account button and uploaded the project. See post prior to yours.
J
 		jimw123 author 2/6/2007

Ok, I fixed the LCID problem and uploaded again. The link is http://demo.asprunner.net/jwilliams%5Fnull...ster_search.asp Go to item #39 and set equal to False. You will get the error.
J
 		Jane 2/7/2007

answered in your personal email.
J
 		jimw123 author 2/7/2007

I never received the email.
J
 		Jane 2/8/2007

This bug was fixed.

Please download and install latest update of ASPRunnerPro:

http://www.asprunner.com/files/asprunnerpro411.exe

Then rebuild your pages.