> Syntax error or access violation: You have an error in your
> SQL syntax.
> Check the manual that corresponds to your MySQL server
> version for the right syntax to use near 'update) VALUES
> ('test', 'f fdsf', '2004-02-20')'
Your MySQL error isn't because of the date, it's because you've got a field
name that is a reserved word - your column named "update" is causing
confusion. Try adding single-ticks (`) around that field name and see what
happens.
Alternately you could (and more to the point should) rename that field.
I have an app that is date intensive that runs off MySQL, the CreateODBCDate
will work just fine once you change that column name.
Good Luck!
Hatton
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
