on both dates. If it throws an error, it should at least say
'EVENT_DATE <= {d '2005-06-04'} AND
EVENT_DATE > {d '2004-06-03'} AND display='yes''
And you're still not using <cfqueryparam>
Pascal
> -----Original Message-----
> From: Eric Creese [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 4 juni 2004 22:40
> To: CF-Talk
> Subject: RE: SQL date record retrevial problem
>
> thanks but I got this
>
> [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
> Microsoft Access Driver] Syntax error (missing operator) in
> query _expression_ 'EVENT_DATE <= d '40041-12-31'} AND
> EVENT_DATE > #6/3/2004# AND display='yes''.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
