>>>>> "Steve" == Steve Webb <swebb@stripped> writes:
Steve> Another good guess, but I have a "DATETIME" and a "TIMESTAMP" field. No
Steve> "DATE" fields. I sense, from the proposed solutions so-far, that there is no
Steve> ODBC problem and just a date issue. Could it be that the clocks on the server
Steve> and the client machine are just "enough" off to cause a problem?
I don't think so.
Could you try to execute the query in the mysql client and try to find
out why it doesn't find any matching rows.
Steve> | | query: Query = "UPDATE Fixed_Assets SET login='test' WHERE ID = 9 AND
Steve> login = 'crook' AND system_name = 'alpha' AND type = 'cpu' AND description =
Steve> 'PB46A-AA' AND location = 'FL2-2080' AND serial_number = 'KA513VUKN9' AND
Steve> nsf_number IS NULL AND ppe_number = 'PPE000000701' AND po_number = '52391' AND
Steve> vendor = 'DEC' AND date_installed = 19950413000000 AND status IS NULL AND
Steve> timestamp = 19961112000000 AND project = '170113' AND architecture = 'DEC' AND
Steve> operating_system IS NULL"
Regards,
Monty
