[thelist] ASP INSERT INTO problem

Michele Foster michele at wordpro.on.ca
Wed Nov 1 10:25:44 CST 2000

Hi Larry,

Hmm..for some reason this message was just received now.. Nov. 1, 11:22 EST.

Anyway, try getting rid of the # around the date, and instead treat it like
you would any other number, i.e. no quotes. I pulled my hair out for hours
last week trying to figure out the same thing.



> Here's a very simple SQL statement that I'm trying to use to create a new
record in a simple Access database using ASP:
> INSERT INTO chatter (name, date, comments, files) VALUES ('bob',
#10/31/00#, 'just some words', 'files.jpg')

More information about the thelist mailing list