[thelist] [SQL] INSERT INTO syntax

[Tim Burgan]

Hello,


I've really clogged everyone email box the last for days with my mass of
post for help. Sorry about that and thanks for all your help.


I'm getting this syntax error regarding my INSERT INTO SQL statement:

Warning: (null)(): Invoke() failed: Exception occurred. Source:
Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC
Microsoft Access Driver] Syntax error in INSERT INTO statement. in
C:\www\xampp\htdocs\YWAM\site\02_templates\rebuild\inc\admin_countdown_create.php122


I really must be missing something really small. My SQL is:

   INSERT INTO tblCountdown (event, date)
   VALUES ('eventName', '2/05/2007');


If I exclude the date field, everything works fine. When I include it
again.. errors. The database is Access.

The data-type format of the field within Access is short date (eg.
2/05/2007).


Where is my syntax error?


Tim