Let me get this right. You want to select a one row and col from another table and insert it into another? Or do you want to select multiple rows? Maybe you can show us an example.
On Tue, Aug 30, 2011 at 8:14 AM, Ben Milum <[email protected]> wrote: > > 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:5523 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
