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