Reading large lob data from SQL

i gotta missing something, don't see what.  have seen postings on topic years, , answer same, i've done things.

 

i have cf script grabs webpage via cfhttp, , stores content in sql server 2008 table in text datatype.  stores @ time of insert value of cf expression len(cfhttp.filecontent) in column (bigint).

 

another scripts comes along , tries analysis, select of data. ever gets 64,000 bytes. displays value stored length during insert, current datalength reported sql, , datalength of variable in cf resutls set query.  data in database.  can query in ssms clause finds "/html" in data, indicate of data there.

 

both scripts use same datasource. datasource setup (correctly believe) as:

login timeout (sec)
clob	-- enable long text retrieval (clob).
blob	-- enable binary large object retrieval (blob).
long text buffer (chr)
blob buffer(bytes)
disable autogenerated keys

 

i cannot think of other cf admin paramaters change.  happens on multiple cf servers across multiple versions (8, 9 , 10) of cf.

 

the code retrieval is:

 

		<cfquery name="results"  datasource="talbot_exsto">
			select  page_text,page_size ,datalength(page_text) dblen
			urlcheck..urlcheck_results (nolock)
			where result_id=#url.resultid#
		</cfquery>

 

#results.page_size# bytes in http results, #results.dblen# bytes in database,

#len(results.page_text)# bytes in coldfusion resultset

for record #url.resultid#

 

which outputs:

108016 bytes in http results, 108001 bytes in database, 64000 bytes in coldfusion resultset record 1774479

 

what have missed?

 

thanks everone,

reed

tried few more variations on admin settings, no luck.  have ideas?

thanks

reed

More discussions in ColdFusion

adobe