Response Buffer Limit Exceeded??? - Snitz™ Forums 2000

The Forum has been Updated

The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.

Response Buffer Limit Exceeded??? - Posted 23 Dec 2008 13:06 (1680 Views)

Da_Stimulator

DEV Team Forum Moderator

Posts: 3373

3373

Hi, long time no see ppl

so... I'm writing a web app to show product listing, and I just added categories to that app.
I added this little chunk of code and it threw an error at me, Response buffer limit exceeded? never seen that one before, and I dont see any errors in my code, AND there is only ONE category in the database at the moment. Help?

Code:


set crs = Server.CreateObject("Adodb.RecordSet")
strsql = "SELECT Cat_Name, Cat_ID FROM P_Categories ORDER BY Cat_Name ASC"
crs.Open strsql, dbConn
  if not(crs.eof) then
    Do while not(crs.eof)
	  response.write("<option value=""" & crs("Cat_ID"))
	  if crs("Cat_ID") = strProductCat then
	    response.write(" SELECTED")
	  end if
	  response.write(""">" & formatString(crs("Cat_Name")) & "</option>")
	Loop
  else
    response.write("<option value=""0"">No Categories Found!!!</option>")
  end if
crs.close
set crs = nothing

I should note that the page worked flawlessly till I added that code ^^

*edit - Response.Buffer=False produced no error, however it also produced NO PAGE... no source, nothing. just a blank browser screen.
I commented out the added code with the same result... so now I dont even know if it's that code or what. The only other things I edited were a couple of SQL statements that shouldn't even be called the way the page is loading...
*edit again - ok I did a process of elimination and the code above IS whats causing the error...<

-Stim

Last edited by Da_Stimulator on 23 December 2008, 13:41

Posted 23 Dec 2008 14:07

HuwR

Forum Admin

Posts: 20611

20611

you will never exit the loop since you are not doing a movenext on the recordset.movenext, so you only ever check the same record over and over again. <

Posted 23 Dec 2008 14:56

Da_Stimulator

DEV Team Forum Moderator

Posts: 3373

3373

... something stupid, i knew it.
Thx Huw<

-Stim

Posted 23 Dec 2008 18:16

SiSL

Average Member

Posts: 671

671

Or you may simple use GetRows and close Recordset and go with For ... Next on array, which I find less dangerous and less resource demand in most cases.<

Last edited by SiSL on 23 December 2008, 18:16

Posted 24 Dec 2008 00:03

Da_Stimulator

DEV Team Forum Moderator

Posts: 3373

3373

I could do that, and I might if this ends up getting big enough to be worried about resources. This is in extremely early development... as I havnt coded for probably 2 or 3 years... its been a while, I find I have to re-learn alot of things.
Like basic f'in HTML for example... lol

If I remember correctly if I had the following HTML code:

Code:


<select name="whatever">
  <option value="this">This</option>
  <option value="that">That</option>
  <option value="select me!" selected>Select Me!</option>
</select>

Then the "Select Me!" would be automatically selected... but apparently thats not the case! Not in firefox anyway... I've tried the above, I've tried <option value="whatev" selected="selected"> and neither seem to work. I've tried capitalized, lowercase, I just dont get it. I DO remember it working...<

-Stim

Posted 24 Dec 2008 00:39

Carefree

Advanced Member

Posts: 4224

4224

~~Try "option selected value"~~
In Firefox, you have to use option value selected="yes", thus:

<select name="whatever">
<option value="this">This</option>
<option value="that">That</option>
<option value="select me!" selected="yes">Select Me!</option>
</select>
<

Last edited by Carefree on 24 December 2008, 00:48