RE: Syntax error on Where statement?

2004-05-05 Thread Robert Orlini
-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

Re: Syntax error on Where statement?

2004-05-05 Thread Charlie Griefer
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

RE: Syntax error on Where statement?

2004-05-05 Thread Robert Orlini
: 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

RE: Syntax error on Where statement?

2004-05-05 Thread Robert Orlini
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

Re: Syntax error on Where statement?

2004-05-05 Thread Charlie Griefer
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

RE: Syntax error on Where statement?

2004-05-05 Thread C. Hatton Humphrey
> > 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

RE: Syntax error on Where statement?

2004-05-05 Thread Robert Orlini
[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

Re: Syntax error on Where statement?

2004-05-05 Thread Charlie Griefer
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