By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,273 Members | 1,032 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,273 IT Pros & Developers. It's quick & easy.

Response Buffer Limit Exceeded

P: 2
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:

Expand|Select|Wrap|Line Numbers
  1. <%
  2.  set con = Server.CreateObject("ADODB.Connection")
  3.  con.Open "File Name=E:\webservice\Company\Company.UDL"
  4.  set rs = Server.CreateObject("ADODB.Recordset")
  5.  
  6. ID=request.querystring("ID")
  7. IF ID <> "" then ID=ID else ID="9726" end if 'show default record 9726 but also allow me to
  8. 'type in a different record number and display that one
  9.  
  10. 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"
  11.  
  12. rs.Open strSQL,con 'open a connection to the database
  13. 'response.write strSql 'output sql string data to the browser
  14. %>
  15.  
  16. <%
  17. 'Response.Buffer=true
  18. 'Response.Flush
  19. %>
  20.  
  21.     <body>
  22. <TABLE BORDER="1" CELLPADDING="2" CELLSPACING="1" WIDTH="100%">
  23. <%
  24.  
  25. ' THESE THREE LINES ARE COMMENTS ONLY...
  26. ' Check to see if the recordset is populated then loop through the records
  27. ' Do this until you reach the end of file
  28.  
  29.     do until rs.EOF
  30.  
  31.     %>
  32.  
  33. <TABLE WIDTH="80%" BORDER=0 ALIGN="CENTER">
  34. <tr><td><% Response.Write RS("GuestName") %></td></tr>
  35. <tr><td><% Response.Write RS("GuestDescription") %></td></tr>
  36. <tr><td><A HREF="<%= RS("URL") %>"><%= RS("Description") %></A></tr></td>
  37. </table>
  38.  
  39. <%
  40. loop
  41. rs.movenext
  42. %>
  43.  
  44. <%
  45. RS.Close
  46. Set RS = Nothing
  47. Conn.Close
  48. Set Conn = Nothing
  49. %>
  50.  
  51.         </table>
  52.   </body>
  53. </html>
  54.  
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:
Expand|Select|Wrap|Line Numbers
  1. <TABLE BORDER="1" CELLPADDING="2" CELLSPACING="1" WIDTH="100%">
  2. <%
  3.  
  4. ' THESE THREE LINES ARE COMMENTS ONLY...
  5. ' Check to see if the recordset is populated then loop through the records
  6. ' Do this until you reach the end of file
  7.  
  8.     do until rs.EOF
  9.  
  10.     %>
  11.  
  12. <TABLE WIDTH="80%" BORDER=0 ALIGN="CENTER">
  13. <tr><td><% Response.Write RS("GuestName") %></td></tr>
  14. <tr><td><% Response.Write RS("GuestDescription") %></td></tr>
  15. <tr><td><A HREF="<%= RS("URL") %>"><%= RS("Description") %></A></tr></td>
  16. </table>
  17.  
  18. <%
  19. loop
  20. rs.movenext
  21. %>
  22.  
  23. <%
  24. RS.Close
  25. Set RS = Nothing
  26. Conn.Close
  27. Set Conn = Nothing
  28. %>
  29.  
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"?
Apr 6 '07 #1
Share this Question
Share on Google+
1 Reply


shweta123
Expert 100+
P: 692
Hi,

Try to write the code like this:
<%
while not rs.eof%>

<TABLE WIDTH="80%" BORDER=0 ALIGN="CENTER">
<tr><td><A HREF="<%= RS("URL") %>"><%= RS("Description") %></A></tr></td>
</table>

<%
rs.movenext
wend
%>
Apr 22 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.