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.
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?
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...<
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...<
Postet den
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.
<
Postet den
... something stupid, i knew it.
Thx Huw<
Thx Huw<
Postet den
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.<
Postet den
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:
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...<
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...<
Postet den
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>
<