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

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_date column

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 unless the

Re: Syntax error on Where statement?

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

RE: Syntax error on Where statement?

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

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 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 error on Where statement? Sounds good. I

RE: Syntax error on Where statement?

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