[thelist] [SQL] INSERT INTO syntax

[Jon Haworth]

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
happens.

HTH
Jon



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