I have a problem concatenating in sql (using Oracle). I'm doing: SELECT a_fname || ',' || a_lname
If I use a comma in the concatenation, it doesn't work. If I put in colon it works fine. I posted to a Oracle list about it and they said that my method is fine and works fine for them. They suggested that the error MAY be because I'm using Cold Fusion for the request. While that may or may not be true, I still don't seem to be able to make this work. The error displayed is: [Table (rows 8 columns A_FNAME||','||A_LNAME): [A_FNAME||','|| A_LNAME: [EMAIL PROTECTED] ] is not indexable by A_FNAME||' any thoughts? -- Daniel Kessler College of Health and Human Performance University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:276293 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
