Retrieving large amounts of data

[cqprod]

Why can I only retrieve and display 67,000 characters from a db column (text data type) that contains over 100,000+ characters?:confused;

[Dan Bracuk]

characters or records?

If you are talking about records, I am surprised you can display 67,000
without overwhelming the browser. Back in the Netscape 4 days, we would limit
our results to 500 records for that very reason.

[JMGibson3]

I don't know how things may have changed and I'm stuck WAY back on CF 4.5, but:

In the Cold Fusion Administrator, in the Data Source pages in the CF Settings
page for each data source, you may (will on 4.5) run across a checkbox to
"Enable Retrieval of Long text" which is disabled by default. Once checked you
can then set your own maximums in the "Long Text Buffer Size" just below.

If your hosted, your hosting company will have to do this (assuming they have
no objections of course).

[cqprod]

We are hosting on-site. I will ask the admin to do this.

Thank you.

[cqprod]

I was trying to get back data (characters) from a particular column that was
submitted from a textarea.

Just a note some browsers do impose limits on the amount of data that can be
submitted in a textarea, like 32 or 64 kilobytes (32,768 or 65,536 characters)
so I've read but I've never run into that problem. And if anyone else is
wondering how to check the length on a text, ntext, image or varbinary data
type they should use the datalength() function instead of len() in sql.

I will be more mindful to come back and answer other peoples questions.

Thanks :cool;

[cqprod]

That worked, thank you JMGibson3. :D