So your first query would do select emailcol from sometable
You can create a list of it by doing: <cfset bigOleList = valueList(queryname.columname)> valueList takes an optional argument to specify the list delimiter. This will give you one string value with all the data in a list. On Tue, Aug 30, 2011 at 9:39 AM, Ben Milum <[email protected]> wrote: > >>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. >> >> >> >>> > > Sorry I meant one column, not quite sure why I typed row. I'm trying to pull > all of the client_email column from the client table, filter it and then have > the results write to the Email_to cell on the rfp table as semicolon > delimited if there are multiple results. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:5525 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
