|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
