|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
