[thelist] ASP INSERT INTO problem

L. Floyd lfloyd at sonic.net
Wed Nov 1 10:03:37 CST 2000

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

The fields name, comments, and files are all text or memo data types; date is date data type.  I continue to get this error:

Microsoft JET Database Engine error '80040e14' 

Syntax error in INSERT INTO statement. 

/watercooler/post.asp, line 42

Line 42 is my execute line (MyConnection.Execute(strSQL))

What am I overlooking??  I've been beating my head against the wall!  This is just too simple, right?

- larry

ps:  Happy Halloween!!

More information about the thelist mailing list