[thelist] [SQL] INSERT INTO syntax

Jon Haworth lists at laughing-buddha.net
Mon Jan 24 06:35:57 CST 2005

Hi Tim,
> INSERT INTO tblCountdown (event, date)
> VALUES ('eventName', '2/05/2007');
> If I exclude the date field, everything works fine. 

I believe "date" is a reserved word, so you'll have problems using it as a
column name. Try changing the name to "eventDate" or something and see what


This message has been scanned for viruses and
dangerous content by Swift Internet, and is
believed to be clean.

More information about the thelist mailing list