Yup - that was one of the first things I tried. Bomb: DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver
+] Syntax error in date in query expression 'WorkOrd.StatCode5 = 'C' a
+nd (
WorkOrd.ClearDate is NULL or (
WorkOrd.ClearDate BETWEEN #Pa_RaM000# and #Pa_RaM001#
)
)'. (SQL-37000)(DBD: st_execute/SQLExecute err=-1) at O:\Scripts\P
+erl\ServiceReports\test-av-citigroup.pl line 54.
Uncaught exception from user code:
Could not execute statement. Error:[Microsoft][ODBC Microsoft Acce
+ss Driver] Syntax error in date in query expression 'WorkOrd.StatCode
+5 = 'C' and (
WorkOrd.ClearDate is NULL or (
WorkOrd.ClearDate BETWEEN #Pa_RaM000# and #Pa_RaM001#
)
)'. (SQL-37000)(DBD: st_execute/SQLExecute err=-1)
Report run on 2003-03-19 Report runs from 2003-03-19 to 2003-03-2
+0.
|