Logo

    Home    |    New Thread
Message
    error message!!! in DB MSG
Author
 seopo
Date
 01/04/2001 11:28 AM
I have a problem in DB MSG at brinkster
It is in a SQL statement...
'select * from tablename'--> It is well operated...
But 'delete from tablename' or 'update set No =1 where No=3...etc'----> It is not well operated....
There appears error message
It is.....
Query Results
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/DatabaseManager.asp, line 473 ""
I want to find a way...
please! give me an answer....

Responses
   RE: error message!!! in DB MSG
Author
 nhsa
Date
 01/04/2001 3:00 PM
DELETE * FROM tablename WHERE stringfield='stringvalue'
UPDATE tablename SET stringfield='hello' WHERE numberfield=10
HTH
Nige - nhsa@yahoo.com
   RE: error message!!! in DB MSG
Author
 hiflyer
Date
 01/05/2001 4:28 AM
Nige is right with his SQL string examples, but the error you are getting is because you are trying to perform operations on a recordset which has been closed. If you look at your code you will probably find a line such as dbConn.close, or RS.close or Set RS = nothing somewhere before line 473.
HTH,
Bod.
www5.brinkster.com/hiflyer


Copyright © 2003-2008 YesSoftware All Rights Reserved.