Date Truncation on CFquery Update

Probably Max data length in cf admin.  Look at the advanced DB connection settings.  Will be set to default of 60000 characters.  I ran into something similar saving a wddx variable. Cheers, Rob On Jun 13, 2012 12:17 PM, "Robert Harrison" <robert@austin-williams.com> wrote: > > I have a client who is essentially entering a document of 50+ pages into a > text area field (tiny MCE). The data is being saved to a data base via > CFquery Update.  The data base is MS SQL server and the field length is set > to VARCHAR(MAX).  Data is being truncated on update to data base (same > place every time). > > I have checked and the data is not being lost by the text area. If I > display the post field after the Update Query, all the data is there. It's > definitely being truncated either by CFQuery or by the data base. > > I have (temporarily) removed cfqueryparam, so that is not the culprit. > > Any ideas what is causing the truncation? > > 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_ > >