Insert table - ASP and access database

enaj · enaj

Hi,

I am working towards trying to insert data in to two tables from one form.

My code won't work so I have simplified everything.

I currently have a database with two tables. I have cut the tables down to
three fields each for experimentation. Using the Command dialog box I can
successfully insert into one of the tables. However I can not insert into the
second table. I have tried inserting into the second table only and am still
getting the same error message:

Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/abstracts/add4.asp, line 16

I can only conclude that there is something wrong with my database. The table
in question has three fields: userid, surname, and firstname.

The code I'm using to experiment with is pasted below. I have checked and
rechecked my variables.

I'm totally stuck. Any ideas? I'm very new to all this....

THanks

Jane

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<%

if(Request.Form("surname") <> "") then Command1__sur = Request.Form("surname")

%>
<%

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_abstracts_STRING
Command1.CommandText = "INSERT INTO user (surname) VALUES ('" +
Replace(Command1__sur, "'", "''") + "' ) "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form name="form1" method="post" action="">
<p>title
<input name="title" type="text" id="title">
</p>
<p>surname
<input name="surname" type="text" id="surname">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</body>
</html>

Julian Roberts · Julian Roberts

Try using [user] instead of user. Best to rename the table though. user is a
reserved word.

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Insert table - ASP and access database

Thread Tools

Display

Insert table - ASP and access database

Similar Questions and Discussions

Using Flash to insert data into a MS Access database

Need Utility to insert a CSV to ACCESS Table

Insert to Access database error*** Please Help

Login - multi table insert for registrant; subsquent login insert page requests into joined 'Selection' Table

How can I create a table in my Access database dynamically in ASP?

Re: Insert table - ASP and access database

Posting Permissions