[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
happens.
HTH
Jon
--
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