My understanding is that SQL Server won't let you append text to a field of datatype TEXT. If you change the datatype to varchar or char, it should work fine.
-- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----Original Message----- > From: Haggerty, Mike [mailto:MHaggerty@;mbda.gov] > Sent: Thursday, October 17, 2002 1:51 PM > To: CF-Talk > Subject: Concatenate SQL Text Field > > > [MERANT][ODBC SQL Server Driver][SQL Server]Invalid operator for > data type. > Operator equals add, type equals text. > > That's the error. > > SQL = "UPDATE tbl_tasks SET comment = comment + 'I am entering some new > comments (Michael Haggerty, 10/17/2002) ' WHERE task_id = 5000" > > That's the SQL statement. > > For whatever reason, SQL Server does not seem like it is in the mood to > allow me to concatenate the value of a text field with new text. > > I have searched through the books on line to find another concatenation > operator, without any luck. > > Does anyone know how to concatenate strings to a text field? Please help! > > M > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
