Are you sure that its only returning name as if you are looking at it in
your browser the browser will think that the <> section is a tag...
Ensure that you wrap the output with HTMLEditFormat
Ie
<cfoutput>
#HTMLEditFormat(makeFriendly.Friendly)#
</cfoutput>
HTH
-----Original Message-----
From: Tyler Silcox [mailto:[EMAIL PROTECTED]]
Sent: 14 November 2001 17:31
To: CF-Talk
Subject: QofQ question...
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
