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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
