|
|
|
|
|
| | |
| |
Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Add a record to DB table - Please help! << |
|
From: |
Mark Sanders |
|
Date: |
6/17/1999 10:33:28 AM |
|
IP: |
158.152.97.203 |
Hi
Im having trouble adding a record to a table in a database. The database is called "shopping" and there is a table in it called "personalinfo". I can retrieve data from the table using ASP but get an error when trying to add a simple record to the table. The error I get is:
"ADODB.Recordset error 800a0bb9
Invalid argument.
/ASPSamp/shopping/newmall/addrec.asp, line 13"
My code is below:
<% @LANGUAGE="VBSCRIPT" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<TITLE>Untitled</TITLE>
</HEAD>
<BODY>
Set Conn = Server.CreateObject("ADODB.Recordset")
Conn.Open "personalinfo", "shopping", adOpenKeyset, adLockPessimistic, adCmdTable
Conn.AddNew
Conn.Fields("job") = "new job"
Conn.Update
Conn.close
Conn = Nothing %>
</BODY>
</HTML>
This code has come from an ASP book so it should work but it doesnt!
PLEASE HELP!! |
Follow Up - Re: Add a record to DB table - Please help! << - John 6/18/1999 7:57:41 AM
Follow Up - Re: Add a record to DB table - Please help! << - anil 7/1/1999 4:33:13 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
