[thelist] ASP INSERT INTO problem

Scott Dexter sgd at ti3.com
Wed Nov 1 10:54:07 CST 2000

> Try changing the names of your "name" and "date" fields in 
> your database.. I
> think one or both of those might be reserved words.
> INSERT INTO chatter (name, date, comments, files) VALUES 
> ('bob', #10/31/00#,
> 'just some words', 'files.jpg')

Also try putting the date in single quotes: '#10/31/00#' though my Access
knowledge is limited (we're 100% SQL Server here)


More information about the thelist mailing list