You have to enable long text retrieval, I'm not sure where this setting is as I haven't had to do it myself. Some one else will probably let you know.
Ade :O) -----Original Message----- From: Noncubicle Corp [mailto:[EMAIL PROTECTED]] Sent: 06 February 2003 15:40 To: CF-Talk Subject: Inserting more than 255 chars from CFQUERY Hi all, I'm beginnig my first CF app in a couple of years, and am putting together a quick prototype of a site. I wish to insert more than 255 characters into a DB column I have made NVARCHAR(2000) in SQL Server 2000. When I pass a value to the CFQUERY tag, it is only inserting the first 255 characters. I would expect this behavior if my field was not large enough, but that is not the case. Can I only achieve this by using a stored procedure? (I will likely do that for production anyway, but I would like to know why it is happening anyway) Is it actually ODBC which is doing the truncating, or is this a CFQUERY issue? Any info appreciated. James Milks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
