in reply to Re: Re: DBD::ODBC, Access, date comparisons
in thread DBD::ODBC, Access, date comparisons

Have you tried WHERE WorkOrd.ClearDate >= #?# as your clause fragment?

  • Comment on Re: Re: Re: DBD::ODBC, Access, date comparisons

Replies are listed 'Best First'.
Re: Re: Re: Re: DBD::ODBC, Access, date comparisons
by finni (Beadle) on Mar 20, 2003 at 17:13 UTC
    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.