Hi Stavros, If you look in the CF administrator -> datasources -> [your datasource] -> Advanced Settings, you should see a setting like "Long Text Buffer" and the ability to set its size. It's probably what is chopping off the rest of your text.
Cheers, Joe On Thu, 13 Jan 2005 06:34:48 -0400, Stavros Tekes <[EMAIL PROTECTED]> wrote: > Hi all! > > I am using CF MX 6.1 for an app I have developed which uses a database in SQL > server 2000. > > One of the tables contains a field of ntext type. Although the size of this > field is supposed to be huge, I noticed that there are some possible > limitations on CF. > > The whole issue popped up, when I tried to insert a very big string in that > field (45536 character long). Although cfquery executed the UPDATE clause > with no exceptions, when I tried to retrieve a record (using cfquery again), > I only managed to get the first 32000 characters. > > I run the update SQL string on the SQL Query Analyzer, and then when I tried > to retrieve the field from CF (using CFQuery again) it resulted in the same > 32000 characters. Obviously it is a problem of CFQUERY when retrieving big > strings from ntext fields. > > Does anyone know if such a limitation exist or the continuous hours I have > spent on it have made me not think straight? > > Thanks, > > Stavros Tekes > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190201 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
