response buffer exceeded

[havey]

Hi, i'm exceeding the buffer size for the asp processing. Instead of increasing the asp resource limit in the server 2003 meta file, Is there a method so a statement can be something like this:
If buffer exceeds 2 megs then

I will be usinjg it like so on an asp to display db results:
If buffer exceeds 2 megs then
' stop trying to write the record set to the asp, instead create output csv

Thanks

[ghell]

I'm pretty sure that this isn't possible. However there are ways to determine how much data you will be dealing with in advance. If you use ms sql server there are stored procedures that can tell you things about physical data size, if not you can do it manually by working out how much 1 record would be (unless it uses any types which are actually pointers to data such as the Text type, memo in access) and multiplying that by no of rows to extract.

you should be able to disable the response buffer for the page though if that helps

http://www.w3schools.com/asp/showasp.asp?filename=demo_buffer