|
|
|
|
|
| | |
| |
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: |
SQL Update |
|
From: |
Charles |
|
Date: |
9/2/2002 7:12:20 AM |
|
IP: |
192.116.242.218 |
Why do I get an error message saying: ADODB.Recorset operation is not allowed when the object is closed.
With these codes lines:
Set rs = server.CreateObject("adodb.recordset")
sqlx = "Update intelYoman"
sqlx = sqlx & " Set sugPgisha ='', "
sqlx = sqlx & " tz ='', "
sqlx = sqlx & " shemM ='', "
sqlx = sqlx & " roshem ='' "
sqlx = sqlx & " where misparOved=" & session("misparOved") ' &" AND tz=" & session("tz")
rs.Open sqlx, con
rs.Close
Set rs = Nothing
The error pop up on the line :rs.close
Thanks |
Follow Up - Re: SQL Update - SE*Criper 10/16/2002 9:05:51 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
