|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
adodb recorset updation |
|
From: |
joshua pinto |
|
Date: |
4/5/2000 1:31:34 AM |
|
IP: |
203.197.55.94 |
i am using access as my database ,using asp with vbscript as my scripting language.i have marked a System DSN to the database ,my problem is that i want to update my records using the native ADO methods,eg
rs("name")="jack"
now this is what i have done
set con=server.create object("ADODB.connection")
con.open "xyz"
set rs =server.create object("ADODB.recodrset")
rs.locktype=adlockoptimistic
rs.open "select * from sales",con
rs.addnew
rs("name")="jack"
rs.update
i keep getting the error " THE APPLICATION IS USING ARGUMENTS THAT ARE OF WRONG TYPE ARE OUT OF ACCEPTABLE RANGE OR ARE IN CONFLICT WITH ONE ANOTHER"
i cannot use the "INSERT INTO " statement since i may have to insert null values |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
