[thelist] ASP INSERT INTO problem

Tab Alleman talleman at autobex.com
Wed Nov 1 12:07:12 CST 2000


I'm pretty darn sure that the ##'s is done correctly in his example.

I also think that another way around those field names is to put them in
brackets, like:


> INSERT INTO chatter ([name], [date], comments, files) VALUES
> ('bob', #10/31/00#,
> 'just some words', 'files.jpg')

maybe.

-----Original Message-----

>
> 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)

sgd





More information about the thelist mailing list