Be sure to enable the blob/clob option(s) on the CF datasource if you go with those datatypes.
That one bites me all the time. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -----Original Message----- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Saturday, April 23, 2011 10:29 PM To: cf-talk Subject: Re: Problem Using QueryNew If you are using SQL Server 2000, to avoid truncation you can use TEXT or nText fields instead. These are BLOBS and are not contained by the max row length. The combined max row size for all other fields is 8060, anything above this will be truncated. Since SQL Server 2005 these were depreciated in favour of the new VarChar(max) data type. -- Russ Michaels www.bluethunderinternet.com : Business hosting services & solutions www.cfmldeveloper.com : ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine ** *skype me* : russmichaels ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:343946 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
