Skip to main content
A
Anonymous
June 18, 2009
Answered

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

  • June 18, 2009
  • 3 replies
  • 873 views

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.

    This topic has been closed for replies.
    Correct answer -__cfSearching__-

    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.

    3 replies

    -
    -__cfSearching__-Correct answer
    Inspiring
    June 18, 2009

    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.

    Dileep_NR
    Dileep_NR
    Inspiring
    June 18, 2009

    Hi,

    Just check this url

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

    A
    Anonymous
    June 18, 2009

    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.

    ajithman
    ajithman
    Inspiring
    June 18, 2009

    Hi,

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

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

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices