Link to home
Start Free TrialLog in
Avatar of henderxe
henderxe

asked on

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!
ASKER CERTIFIED SOLUTION
Avatar of _agx_
_agx_
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of henderxe
henderxe

ASKER

agx:

   Thank you very much!

   May seem small, but really big to me!

You're welcome.  It drove me nuts until I figured it out that 1st time too :)