[thelist] [SQL] INSERT INTO syntax

[Craig Burkett]

You need to surround your date value with the hash sign.  i.e.
#12/24/2004#

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Tim Burgan
Sent: Monday, January 24, 2005 6:19 AM
To: [thelist] thelist at lists.evolt.org
Subject: [thelist] [SQL] INSERT INTO syntax

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_c
reate.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



-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt !