Unable to display the entire content of the CF query return result on my CF webpage.

[Guest]

Hi,

I am trying to fetch data from a table (project_reports) which is having one CLOB data type column (details) in it.

This details column is holding huge amount of data in it.

And I am using the below code to fetch & display the data on my CF webpage.

<cfquery name="getReport" datasource="myDS" >
select details from project_reports where project_id = 54516
</cfquery>

<cfoutput query="getReport">#getReport.details#</cfoutput>

ColdFusion is able to process & display some limited amount of data but not the full data.
I want to fetch & display the entire data using ColdFusion.
Can anybody assist me on this? Thanks in advance.

Regards,
Manoz.

[ajithman]

Hi,

Are you sure u r getting all data from the query?

Just dump your query and see if all records are there...

[Dileep_NR]

Hi,

Just check this url

http://molaro.wordpress.com/2008/10/14/output-clob-data-with-coldfusion/

[Guest]

I have resoloved this problem by changing the CF admin settings.

There is a setting in CF administrator page to enable "Long text retrieval (CLOB)" for each data source.
Previously this setting was disabled on my localhost.
Due to which I was unable to fetch the entire CLOB content from the database.
Now I enabled this option and able to fetch & display the entire CLOB content.

Anyway thank you guys for the quick turn around.

[-__cfSearching__- · Accepted solution]

Mamidela wrote:

ColdFusion is able to process & display some limited amount of data but not the full data.

Check the datasource settings in the CF Administrator. Make sure the CLOB (Enable Long Text Retrieval) setting is checked.  When this box is _not_ checked, CF only retrieves the first 64000 bytes.