Yes, this will be the issue: you need to do something like SELECT a_fname || ',' || a_lname as fullname
On 4/26/07, Jochem van Dieten wrote: > 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 -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276299 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
