|
 |
asp_databases thread: Add new information to the table
Message #1 by philip.moh@a... on Tue, 30 Jan 2001 05:03:03 -0000
|
|
Somebody please help! I have the following code in the page.
<HTML>
<HEAD>
<TITLE>Add New Customer</TITLE>
<BODY>
<H1>Customer Info System<BR></H1>
<%
Dim objConn
Dim objRec
set objConn = Server.CreateObject ("ADODB.Connection")
set objRec = Server.CreateObject ("ADODB.Recordset")
objConn.Open "DSN=Sales"
objRec.Open "customer", objConn, adOpenDynamic, adLockOptimistic,
adCmdTable
objRec.AddNew
objRec("custID") = Request.Form("cID")
objRec("custName") = Request.Form("cName")
objRec("custEmail") = Request.Form("cEmail")
objRec("custTel") = Request.Form("cTel")
objRec.Update
%>
</BODY>
</HTML>
but when I run it, I got the following error message:-
Customer Info System
ADODB.Recordset error '800a0bb9'
The application is using arguments that are of the wrong type, are out of
acceptable range, or are in conflict with one another.
/begasp/addnewcust.asp, line 18
Message #2 by "Ken Schaefer" <ken@a...> on Wed, 31 Jan 2001 16:56:39 +1100
|
|
www.adopenstatic.com/faq/800a0bb9.asp
Cheers
Ken
----- Original Message -----
From: <philip.moh@a...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, January 31, 2001 1:09 AM
Subject: [asp_databases] Add new information to the table
> Somebody please help! I have the following code in the page.
>
>
> <HTML>
> <HEAD>
> <TITLE>Add New Customer</TITLE>
> <BODY>
> <H1>Customer Info System<BR></H1>
<snipped for your viewing comfort>
|
|
|
View Cart
