Date Truncation on CFquery Update

2012-06-13 Thread Robert Harrison
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

RE: Date Truncation on CFquery Update

2012-06-13 Thread Edward Chanter
: Date Truncation on CFquery Update 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

Re: Date Truncation on CFquery Update

2012-06-13 Thread Rob Parkhill
Probably Max data length in cf admin. Look at the advanced DB connection settings. Will be set to default of 6 characters. I ran into something similar saving a wddx variable. Cheers, Rob On Jun 13, 2012 12:17 PM, Robert Harrison rob...@austin-williams.com wrote: I have a client who

RE: Date Truncation on CFquery Update

2012-06-13 Thread Russ Michaels
huge you might want to see if increasing that setting helps. -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: 13 June 2012 17:17 To: cf-talk Subject: Date Truncation on CFquery Update I have a client who is essentially entering a document