[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