Sounds good. I converted it to date/time.
My dates now display as 2004-03-08. How do I make it display as 03/08/2004 in my forms?
I tried #convert(datetime,convert(char(10),search.maint_report_date,101))#, but it does not recognize datetime.
Robert O.
-----Original Message-----
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 11:46 AM
To: CF-Talk
Subject: Re: Syntax error on Where statement?
As Hatton said, changing maint_report_date to a date/time datatype would
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]
- Syntax error on Where statement? Robert Orlini
- Re: Syntax error on Where statement? Charlie Griefer
- RE: Syntax error on Where statement? Robert Orlini
- RE: Syntax error on Where statement? C. Hatton Humphrey
- Re: Syntax error on Where statement? Charlie Griefer
- RE: Syntax error on Where statement? Robert Orlini
- Re: Syntax error on Where statement? Robert Orlini
- Re: Syntax error on Where statement? Charlie Griefer
- RE: Syntax error on Where statement? Robert Orlini