This topic is locked

Dependent Dropdown Error

3/3/2008 1:11:24 PM
ASPRunnerPro General questions
D
dunga author

hi,

today i tried to set up a dependent dropdown menus in ASP runner and they worked perfectly untill testing of the application online.
The record is being added but when clicking on the "back to list " i get the following error, in demo account and on my locahost as well..

Error Type:

Microsoft JET Database Engine (0x80040E07)

Data type mismatch in criteria expression.

/john/include/commonfunctions.asp, line 654
Browser Type:

Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Embedded Web Browser from: http://bsalsa.com/; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
Page:

GET /john/Banknotes_list.asp


the line 654 reads:
rss.open LookupSQL,dbConnection
...
when I changed the dropdown BACK to what was working there two-three days ago when I posted a tips and tricks, everything crashed and stopped working...

D
dunga author 3/3/2008

and here is the problem on the DEMO account:

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/xeops_hotmail_com/john/include/commonfunctions.asp, line 654

D
dunga author 3/4/2008

anyone can enlighten me on this please???