|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
