Problem with obJRecSet.close

hema · July 5th, 2003, 02:16 AM

I am using the following in my ASP:

strsql ="update biodata set father_name='"&fname&"',email_add='"&email&"' where rollno='"& rollno &"'"

set objRecSet = Server.CreateObject("ADODB.Recordset")

objRecSet.Open strsql, objConn, adopenKeySet, adLockOptimistic

objRecSet.Close

ASP is returning an error at ObjRecSet.Close. Though it is updating the database. The error is Record SET already closed. What is the error? IF i omit the close statement it works fine. Can any one explain?

Hemalatha

NotNowJohn · July 5th, 2003, 07:02 AM

Hemalatha,

If the command you performed in the strsql statement has'nt some returned rows or the values,the closed recordset has returned.
However, in order to prevent an error's occurrence you can check a recordset state before u call Close() method.

Code:

If objRecSet.State <> adStateClosed Then objRecSet.Close

Regards,

...but the Soon is eclipsed by the Moon

Imar · July 5th, 2003, 08:12 AM

In addition to what NotNowJohn has said, there is another way to execute Update queries that will perform a bit quicker.

You don't have to create a Recordset for Insert, Update and Delete queries, because there won't be any records return to the client. You can simply use the Execute method of the Connection object to this:

Code:

objConn.Open
objConn.Execute(strsql)
objConn.Close

This saves you from creating a recordset that is never used.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

hema · July 7th, 2003, 07:07 AM

Thanks both of u.

Hemalatha

Hemalatha