This topic is locked
[SOLVED]

 Null fields

3/11/2003 5:42:02 AM
ASPRunnerPro General questions
author

Hi there, I wonder if you can help me. I've used ASPRunner to create my pages but for some reason when entering or editing the records I sometimes get:
Error number -2147217913

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

URL /asptest/Customers_edit.asp
I've tracked this down to some of the fields are blank (intentional) so is there anyway for the ASP code to allow null fields? similar to NZ in Access?
Hope you can help & thanks for saving me hours & hours of work with this excellent piece of software. Once I'm happy the program can do what I want...it's there bar the null fields I'll be signing up for the full version....worth every penny...or cent <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=13&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
Many Thanks
Ninja

admin 3/11/2003

Hi,
one of possible reasons here: you have some fileds in MS Access database that do not allow zero-length strings. It will break when you insert empty strings into database.
If you could zip and send me all content of your output folder including database I'll take a look what's wrong with it.
Just send it to support At xlinesoft.com
Sergey Kornilov