-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 cf
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 e
: 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
2004 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
r 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 tr
> > 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 unles
[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_d
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
8 matches
Mail list logo