• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 556
  • Last Modified:

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!
0
henderxe
Asked:
henderxe
  • 2
1 Solution
 
_agx_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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now