Coldfusion 8 query not reading all (or truncating) results from table
Posted on 2010-09-15
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#">
idlist_id = <cfqueryparam cfsqltype="cf_sql_varchar" value="#URL.id#" />
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.