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:190197 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
