Robert O.
-----Original Message-----
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 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 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 database
itself is holding the trailing space. Conversion to a date type field would
be a good suggestion.
Hatton
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.667 / Virus Database: 429 - Release Date: 4/23/2004
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]