[thelist] ASP INSERT INTO problem

Tab Alleman talleman at autobex.com
Wed Nov 1 10:19:48 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.

stupid, huh?  :)

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of L. Floyd
Sent: Tuesday, October 31, 2000 7:59 PM
To: thelist at lists.evolt.org
Subject: [thelist] ASP INSERT INTO problem

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

For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !

More information about the thelist mailing list