Forums
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
%>
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.