Get ready for BLACK FRIDAY shopping starting in

Forums

ASP

This topic is locked

Adding second recordset error

Posted 12 Apr 2005 17:56:41
1
has voted
12 Apr 2005 17:56:41 Christie Mason posted:
I've been using DW for ASP and CF for a few years. Yesterday I developed a page with mutliple recordsets and it was working fine. I deleted an unneccessary recordset last night and when I retest the page this AM, I received an "unspecified error". To make a long story short, I tried developing a new page and it works fine on the first recordset but adding a second recordset, have tried multiple tables and multiple recordsets, results in the same error.

Same problem for ASP - VBScript and ASP - JavaScript.

I'd be grateful for any suggestions, I've turned off extensions, rebooted, scanned for viruses, turned off the firewall, compacted and repaired the Access db - same error each time.



Replies

Replied 12 Apr 2005 18:38:45
12 Apr 2005 18:38:45 adam partridge replied:
are your recordsets being closed properly

i.e. does the page contain the corresponding close statements to your recordsets

<%
Recordset1.Close()
Set Recordset1 = Nothing
%>


Replied 12 Apr 2005 18:42:02
12 Apr 2005 18:42:02 Christie Mason replied:
I checked the recordset closing tags because sometimes DW gets a tad confused and duplicates close statements.

Reply to this topic