> > 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]

Reply via email to