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:2730 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
