[thelist] close connection
Scott Dexter
sgd at ti3.com
Mon Mar 12 11:07:39 CST 2001
What is/are the sql string you're using? Remember that unless there is a
recordset generated (that actually has rows; a recordset that has EOF and
BOF true is a closed recordset), you don't need to explicitly close it.
--What I do in that closeConnection() routine is usually throw On Error
Resume Next in there so I don't have to worry about it in cases where the
recordset isn't open....
sgd
--
work: http://www.ti3.com/
non: http://thinksafely.org/
> -----Original Message-----
> From: Andrew Martin [mailto:comitque at hotmail.com]
>
>
> I keep getting an error when I try to modify a record in my
> database. The
> update, delete, or add all work; the changes get made,
> however, I still get
> this error:
> " ADODB.Recordset error '800a0e78'
>
> The operation requested by the application is not allowed if
> the object is
> closed.
>
> /preload.asp, line 47 "
More information about the thelist
mailing list