Can you concatenate fields in a query of queries select statement? <cfquery name="makeFriendly" dbtype="query"> SELECT Name + ' <' + Email + '>' AS Friendly FROM getEmails </cfquery>
..it's only returning the "Name" and not "Name <[EMAIL PROTECTED]>" in the Friendly column. I know I should (and I am going to implement) concatenating the fields in the original query. But I'm just setting up a debug for my app and I came across this and I just got's to know-> Tyler Silcox email | [EMAIL PROTECTED] website | www.gslsolutions.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
