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