instead of asking 'is that it?' (in relation to trimming the report_date
value), why not simply try it?
other than that i'd suggest that if your maint_report_date column is a
date/time datatype, you use a createODBCDate() function around the value
(and drop the single quotes).I'd futher suggest
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 11:19 AM
To: CF-Talk
Subject: Re: Syntax error on Where statement?
instead of asking 'is that it?' (in relation to trimming the report_date
value), why not simply try it?
other than that i'd suggest that if your maint_report_date column
SQL = Update maintenance_report SET maint_report_impact_search = 'NO'
Where maint_report_date = '06/10/2004 ' and id = 9
One dumb question I might ask - what is the field type for the
maint_report_impact_search and id fields?
As far as the date field, you'll need to trim that data unless the
.
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
11:39 AM
To: CF-Talk
Subject: RE: Syntax error on Where statement?
SQL = Update maintenance_report SET maint_report_impact_search = 'NO'
Where maint_report_date = '06/10/2004 ' and id = 9
One dumb question I might ask - what is the field type for the
maint_report_impact_search and id fields
: 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
use dateFormat() on the presentation side.
#dateFormat(maint_report_date, 'mm/dd/')#
- Original Message -
From: Robert Orlini [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 8:51 AM
Subject: RE: Syntax error on Where statement?
Sounds good. I
: 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
8 matches
Mail list logo