[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.
HTH,
Michele
> 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