2. ASPRunnerPro General questions
  3. [SOLVED]  Dependant Lookup
This topic is locked
[SOLVED]

 Dependant Lookup

 		8/4/2011 8:24:11 AM
ASPRunnerPro General questions
S
 Scruffy author

Just having a dabble with dependant lookups. It works fine in the project (6.3 build 7474) but when i build and publish i get the following error
Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/admin/include/aspfunctions.asp, line 1255
when accessing the page.
Any ideas on getting this to work?
Sergey Kornilov admin 8/4/2011

Make sure link fields in both lookup tables are of the same datatype.
If this doesn't help contact support directly sending your project files and database.
S
 		Scruffy author 8/5/2011



Make sure link fields in both lookup tables are of the same datatype.
If this doesn't help contact support directly sending your project files and database.


Thanks, i've emailed the project and database to support.
The two fields are both numbers.
S
 		Scruffy author 8/5/2011



Thanks, i've emailed the project and database to support.
The two fields are both numbers.


Ok, many thanks. I obv. misunderstood the tutorial and thought the output would be text rather than the id. Have changed these fields now and it's working.
Many thanks