|
|
|
|
|
| | |
| |
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: |
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
