Coldfusion 8 query not reading all (or truncating) results from table

Hello:

   I running a pretty simple query below that returns 64000 characters, even though there are 383647 characters in the table.   I don't receive any errors.

  <cfquery name="getIDListQuery" datasource="#dbName#" username="#dbUserName#" password="#dbPassword#">
          SELECT
                HTMLCodeFormat(list_values)
            FROM
                art_idlist
            WHERE
                idlist_id = <cfqueryparam cfsqltype="cf_sql_varchar" value="#URL.id#" />
        </cfquery>

  If the character count is less than 64000, then it processes fine, but anything over 64000 gets truncated.

  NOTE:  I've switched between "integer" and "varchar" with no change in the results.

  Any assistance appreciated.

  Thanks!
henderxeAsked:
Who is Participating?
 
_agx_Connect With a Mentor Commented:
You need to enable CLOB fields in the datasource. Otherwise CF will limit the results to 64K.

CF Administrator => Select the datasource => Advance settings
Check Enable long text retrieval (CLOB)
0
 
henderxeAuthor Commented:
agx:

   Thank you very much!

   May seem small, but really big to me!

0
 
_agx_Commented:
You're welcome.  It drove me nuts until I figured it out that 1st time too :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.