I'm getting this error when I test this page. Here is the error:
Response object error 'ASP 0251 : 80004005'
Response Buffer Limit Exceeded
/test/test4.asp, line 0
Execution of the ASP page caused the Response Buffer to exceed its configured limit.
Here is the entire asp page code:
-
<%
-
set con = Server.CreateObject("ADODB.Connection")
-
con.Open "File Name=E:\webservice\Company\Company.UDL"
-
set rs = Server.CreateObject("ADODB.Recordset")
-
-
ID=request.querystring("ID")
-
IF ID <> "" then ID=ID else ID="9726" end if 'show default record 9726 but also allow me to
-
'type in a different record number and display that one
-
-
strSQL = "SELECT *, T_Programs.ID AS Expr1, T_ProgramGuests.ProgramID AS Expr2, T_ProgramGuests.GuestName AS Expr3, T_ProgramGuests.GuestDescription AS Expr4, T_ProgramLinks.URL AS Expr5, T_ProgramLinks.Description AS Expr6 FROM T_ProgramGuests CROSS JOIN T_Programs CROSS JOIN T_ProgramLinks"
-
-
rs.Open strSQL,con 'open a connection to the database
-
'response.write strSql 'output sql string data to the browser
-
%>
-
-
<%
-
'Response.Buffer=true
-
'Response.Flush
-
%>
-
-
<body>
-
<TABLE BORDER="1" CELLPADDING="2" CELLSPACING="1" WIDTH="100%">
-
<%
-
-
' THESE THREE LINES ARE COMMENTS ONLY...
-
' Check to see if the recordset is populated then loop through the records
-
' Do this until you reach the end of file
-
-
do until rs.EOF
-
-
%>
-
-
<TABLE WIDTH="80%" BORDER=0 ALIGN="CENTER">
-
<tr><td><% Response.Write RS("GuestName") %></td></tr>
-
<tr><td><% Response.Write RS("GuestDescription") %></td></tr>
-
<tr><td><A HREF="<%= RS("URL") %>"><%= RS("Description") %></A></tr></td>
-
</table>
-
-
<%
-
loop
-
rs.movenext
-
%>
-
-
<%
-
RS.Close
-
Set RS = Nothing
-
Conn.Close
-
Set Conn = Nothing
-
%>
-
-
</table>
-
</body>
-
</html>
-
This is the output when it is almost working correctly. I'm so close on this. I just need to get the text URL to display correctly.
John H. Doe
author of The Lexicon. His new book is Fooled Again: How the Right Stole the 2004 Election.
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/test/test3.asp, line 29
So I added rs.movenext to the page. But now it shows a different message. Here is the message:
Response object error 'ASP 0251 : 80004005'
Response Buffer Limit Exceeded
/test/test4.asp, line 0
Execution of the ASP page caused the Response Buffer to exceed its configured limit.
Here is where I put the code:
-
<TABLE BORDER="1" CELLPADDING="2" CELLSPACING="1" WIDTH="100%">
-
<%
-
-
' THESE THREE LINES ARE COMMENTS ONLY...
-
' Check to see if the recordset is populated then loop through the records
-
' Do this until you reach the end of file
-
-
do until rs.EOF
-
-
%>
-
-
<TABLE WIDTH="80%" BORDER=0 ALIGN="CENTER">
-
<tr><td><% Response.Write RS("GuestName") %></td></tr>
-
<tr><td><% Response.Write RS("GuestDescription") %></td></tr>
-
<tr><td><A HREF="<%= RS("URL") %>"><%= RS("Description") %></A></tr></td>
-
</table>
-
-
<%
-
loop
-
rs.movenext
-
%>
-
-
<%
-
RS.Close
-
Set RS = Nothing
-
Conn.Close
-
Set Conn = Nothing
-
%>
-
Did I put the rs.movenext in the wrong spot or is there other code I need to add to the page to make it display GuestName, Description and URL as text link "without errors"?
