Hi all,
I've been getting "Transaction cannot have multiple recordsets with this cursor type. Change the cursor type, commit the transaction, or close one of the recordsets." when I run my asp pages. I am using adodb connection with transcation. I did a very through check to make sure every rs that is opened is closed before I open another and the error occurs on the lines where cnn.execute("some update or delete SQL statements)are. This makes sense for one occasion when a DELETE statment has sub-select in it. So I closed all the rs before the cnn.execute("Delete.."
and then the page worked fine. But what about just pure INSERT statment without subselects? I can't really think of reason why it is giving the same error? Please help.
I've been getting "Transaction cannot have multiple recordsets with this cursor type. Change the cursor type, commit the transaction, or close one of the recordsets." when I run my asp pages. I am using adodb connection with transcation. I did a very through check to make sure every rs that is opened is closed before I open another and the error occurs on the lines where cnn.execute("some update or delete SQL statements)are. This makes sense for one occasion when a DELETE statment has sub-select in it. So I closed all the rs before the cnn.execute("Delete.."
and then the page worked fine. But what about just pure INSERT statment without subselects? I can't really think of reason why it is giving the same error? Please help.
