Daniel Kessler said: > I have a problem concatenating in sql (using Oracle). I'm doing: > SELECT a_fname || ',' || a_lname
> The error displayed is: > [Table (rows 8 columns A_FNAME||','||A_LNAME): [A_FNAME||','|| > A_LNAME: [EMAIL PROTECTED] ] is not indexable by > A_FNAME||' Try aliasing the output. If that doesn't work, please provide the full statement. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by AdobeĀ® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276294 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4