|
|
|
|
|
| | |
| |
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: |
Re: SQL Update |
|
From: |
Jordi |
|
Date: |
12/24/2003 4:29:55 AM |
|
IP: |
195.77.33.58 |
I'd better do this:
set objConn = CreateObject("ADODB.Connection")
objConn.open connectionString
sql = "update table set field=1 where otherfield=2"
objConn.Execute(sql)
You don't need a RecordSet object to throw a direct SQL instruction. A RecordSet is usefull to recover data from the DB. |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
