Handling Very Large Pieces of Textarea Data

[gorilla1]

I have a function that reads textarea data into a variable and then inserts into an access database - standard stuff. However, some of the texarea material is huge - like 50 or 60 pages of data. I got some kind of buffer overflow error - I think when i did the request.form to load the variable, even before I tried the insert. Is there any way to handle very large pieces of data?

G

[raf]

Yes ... and ... no.

What are you doing with the info ? I can't image your gonna display 50 to 60 pages on a website? You normally would brake it up into chapters or whatever and make multiple calls to the db while the user goes through the text.

If you want to keep it as 1 document/page, then it's probably better to just incluse a reference to the file (just the filename) and return only the filename from the db and then use that as an include, or open that page in a popup or whatever.

50-60 pages? Might even be better to make a zipfile of it and have the client downloed it.

I try to keep everything nice within 1 page so i can't imagen a sittuation where you would display 50 pages
:confused: :confused:

[gorilla1]

raf, Thanks, the file idea is good... Agree on your other points. I am involved in a situation of doing something quickly for someone'sweb site - the advisability of so much data on a page is not my choice and not something I will necesarily get to address.

G