I am a complete cf noob so I'm hoping this isn't anything too difficult to do.
I'm trying to get a list of emails from a row on one table into a field on
another table semicolon delimited and based on a variable. I've tried about
everything i can think of, but can't seem to get it to work. In my test I
could only get it to write one email and the semicolon into the field.
Here's the code I've got so far running on my test system.
<cfquery name="EmailFill" datasource="database">
UPDATE RFP
INNER JOIN CLIENTS
ON RFP.SUB_ID = CLIENTs.WANT_ID
SET RFPs.EMAIL_TO = CLIENTS.CLIENT_EMAIL + ''
WHERE rfp_id = #val(rfp_id)#
</cfquery>
Any suggestions would be greatly appreciated.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5522
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
