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!
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"
</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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome. It drove me nuts until I figured it out that 1st time too :)
ASKER
Thank you very much!
May seem small, but really big to me!