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

Data type mismatch in criteria expression.

 		4/11/2003 07:38:46
ASPRunnerPro General questions
H
 houseofit author

Hello.
Error number -2147217913

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

URL /db/admin_com/com_edit.asp

SQL query update [com] set url='http://www.lauritz.com';, timer=1000, logourl='tre.gif', hits=1243, lastshown='', maxtimes=0, kioskID='test1' where autonumber=3
What do i do
Ps. Sorry for the short question, but i'm lost....
TT
H
 		houseofit author 4/11/2003

I found another mail about this :
"Empty values are not allowed and as of right now ASPRunner do not substitute empty values with NULLs for date and time fields."
Can't i have an empty value in a date field ???
Sergey Kornilov admin 4/11/2003

Hi,
sure you can have NULL values in DATE/DATETIME but it's not supported in ASPRunner yet.

We fixing this in the next release.
Serge Kornilov
500030 4/22/2003

Having blank dates is a requirement before my project can go ahead.

Unfortunatly this also determins the success or otherwise of my evaluation/purchase.
Roughly when is the next release of asprunner expected?
In the mean time can I manually change the generated code to save blank dates as null?
This is otherwise a great little programe.
David.
Sergey Kornilov admin 4/24/2003

Hi,
beta version will be available until the end of April.
Sergey Kornilov