|
|
|
|
|
| | |
| |
Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
