[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interfa

[supersal666]

Hi everyone, have a problem where this error occurs sometimes when trying to view refunds:

Refund Checking fault occurred
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Invalid date, time or timestamp value.
/refundcheckingsql/reports/CalcRiskInclude.asp, line 109

the line of code is:

thisquery = "select type as tender from dlpaid where stor = '"&istor&"' and tran = '"&itran&"' and till = '"&itill&"' and date1 = '"&right(idate, 4)&"-"&right(left(idate, 5), 2)&"-"&left(idate, 2)&"' "

set ConnRsOrig =oconnPV.execute(thisquery)

The date is stored in a my sql database as type smalldatetime.

Has anybody any idea why this error is occuring. It is strange because the query runs successfully sometimes but not all the time.

Thanks

Sally

 

[ca8msm]

Try asking in forum333

You should also read this if you want to avoid the possibility of someone deleting your entire database.




------------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions

 

[supersal666]

Thanks mark, I did not write this code I am just trying to fix the error, hence why I'm not sure what the problem is.

Thanks anyway

Sally