probably be preferrable. Doing that, the code I gave you should work
(assuming that id is an integer).
Otherwise, if you're going to leave it as a char field, change the cfsqltype
in the first <cfqueryparam> to cf_sql_char.
opt for the former if possible.
Charlie
----- Original Message -----
From: "Robert Orlini" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 05, 2004 8:23 AM
Subject: RE: Syntax error on Where statement?
> Thanks Charlie. I tried the trim function and it did not help.
>
> The maint_report_date column is a char field. Should it be a date/time
datatype in order for this to work properly?
>
> The code you sent still gives the syntax error.
>
> Robert O.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]