Still doesn't require you to do it at the SQL side, just create a var on the cfside into a JS var where you add the line break and the output.
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Bruce Sorge To: SQL Sent: Fri Feb 16 19:07:41 2007 Subject: Re: How to do a line break in SQL As I stated above, I have the text area showing this information bound to a select list, so when I click on a different IEA, their contact information fills the textarea, thus the need to do the line break on the SQL end. Bruce On 2/16/07, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > > What for though? Just return them individually and output them using > ColdFusion with a line break. Seems a little odd that you want to format > a > result at the SQL side. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2731 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
