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
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?
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