This topic is locked

Data type mismatch error with Mulit select drop down on list page

12/7/2006 7:52:07 AM
ASPRunnerPro General questions
H
haggecha author

I have a Scope field as an input field set as a memo and works with a text field input, I want to have it populated with a mulit select drop down list using a look-up table with a table that contians an item number and item name, I am displaying the item name and want the item number as the data for for example the data entered into the scope field would be 101, 103,106. the record is sucessfully added and I see it in the MS Access, but when I use a list or view feature, and this record is diplayed I get....
Technical information

Error number -2147217913

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

URL /ReviewAdmin/TblReviews_list.asp

SQL query select top 20 [ReviewID], [DocID], [MeetingLocationID], [StatusID], [ReviewerID], [BaselineID], [DocumentLocationID], [Moderator], [ReviewDate], [StartTime], [ReviewHours], [NumAtendees], [CriticalDefects], [MajorDefects], [MinorDefects], [Suggestions], [ResultID], [Comments], [Scope], [Description] From [TblReviews] order by 1 desc

Solution The SQL error 80040E07 occurs when attempting to use the "Insert Record" or the "Update Record" server behavior to set the value of a column in Microsoft Access with an empty string ("").
Please refer to the following article in the ASPRunner's FAQ for detailed information

http://www.xlinesoft.com/asprunner/faq.htm#datatypemismatch
More info on this error
Any thoughts?
Chad

Sergey Kornilov admin 12/7/2006

Chad,
send me your files or publish your application to Demo Account and send me a link.

I'll see what is wrong.