Did you check "Enable long text retrieval (CLOB)." In your datasource??
Pascal > -----Original Message----- > From: Stavros Tekes [mailto:[EMAIL PROTECTED] > Sent: 13 January 2005 11:35 > To: CF-Talk > Subject: Possible problem of CFQUERY and ntext fields > > 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190200 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
