Discussed this once before, but my client has again exceeded the limits and I'm
not sure where the data is being truncated. I am using the settings below. Any
ideas what could be causing data truncation on long (extremely long) strings?
Data Base = MS SQL Server 2008 R2
Data Field Length = Varchar(MAX)
Input field type = textarea
Insert Statement CFQUERY Param = <cfqueryparam
cfsqltype="CF_SQL_LONGVARCHAR" value="#trim(secured_text1) #">
CF Data Source Advanced Settings = -- Enable long text retrieval (CLOB) is
Checked
Two questions:
1. Is there any place else I should check that may have a setting that's
causing data truncation?
2. Is it possible the CFQUERYPARAM type CF_SQL_LONGVARCHAR is causing the
truncation. I see I could also use cfsqltype="CF_SQL_CLOB", but that does not
seem to be supported on MS SQL Server.
Any thoughts as to where the truncation may be occurring?
Thanks
Robert Harrison
Director of Interactive Services
Austin & Williams
Advertising I Branding I Digital I Direct
125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788
T 631.231.6600 X 119 F 631.434.7022
http://www.austin-williams.com
Blog: http://www.austin-williams.com/blog
Twitter: http://www.twitter.com/austin_
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351911
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
