Thanks Dave, I'll try this out and with caffeine this time ;-)
-----Original Message----- From: Dave Phillips [mailto:[email protected]] Sent: Wednesday, October 07, 2009 10:21 AM To: cf-newbie Subject: RE: building a list help Bob, Probably a few different approaches you can take here, but if all you want is a list of the all the e-mail addresses from your query and combine them into one list, try this (untested): <cfif getformEmails.recordCount> <cfset lsCCEmailAddresses = valueList(getFormEmails.cc_email1) > <cfif listLen(valueList(getFormEmails.cc_email2))> <cfset lsCCEmailAddresses = lsCCEmailAddresses & "," & valueList(getFormEmails.cc_email2) > </cfif> <cfif listLen(valueList(getFormEmails.cc_email3))> <cfset lsCCEmailAddresses = lsCCEmailAddresses & "," & valueList(getFormEmails.cc_email3) > </cfif> <cfif listLen(valueList(getFormEmails.cc_email4))> <cfset lsCCEmailAddresses = lsCCEmailAddresses & "," & valueList(getFormEmails.cc_email4) > </cfif> <cfelse> <cfset lsEmailAddresses = ""> </cfif> FYI - You don't need to do a <cfparam> to specify that columns from a query exist. When you execute a query, even if you don't get any data back, you still get the column names, so those lines of code are unnecessary. Dave Phillips -----Original Message----- From: Imperial, Bob [mailto:[email protected]] Sent: Wednesday, October 07, 2009 9:04 AM To: cf-newbie Subject: building a list help Hi folks, I am trying to get my head around coding a list based on query results and I'm just not seeing it. I don't know if my approach is wrong and maybe I should be using the listAppend() function or what. I have a query that grabs the values from 4 fields that hold email addresses. The result set may or may not return a value for each so I need to somehow account for those in building a final list of email addresses that I can drop into the CC field in emails. Here's roughly what I have thus far: <cfquery name="getFormEmails" datasource="#dsdata3#"> SELECT * FROM tblrequesttypes WHERE request_type = '#form.PageTitle#' </cfquery> <cfparam name="getFormEmails.cc_email1" default="" /> <cfparam name="getFormEmails.cc_email2" default="" /> <cfparam name="getFormEmails.cc_email3" default="" /> <cfparam name="getFormEmails.cc_email4" default="" /> This is the part that's making mush of my brain and has me stumped. In this particular instance I get 2 out of 3 email addresses that are in the result set. <cfif Len(getFormEmails.cc_email1)> <cfset CCList = getFormEmails.cc_email1 /> <cfif getFormEmails.cc_email2 NEQ ""> <cfset CCList = #CCList# & "," & getFormEmails.cc_email2 /> <cfelse> <cfif getFormEmails.cc_email NEQ ""> <cfset CCList = #CCList# & "," & getFormEmails.cc_email3 /> <cfelse> <cfif getFormEmails.cc_email4 NEQ ""> <cfset CCList = #CCList# & "," & getFormEmails.cc_email4 /> <cfelse> <cfset CCList = #CCList# & "," & getFormEmails.cc_email3/> </cfif> </cfif> <cfset CCList = getFormEmails.cc_email1 /> </cfif> </cfif> <cfoutput>#CCList#</cfoutput> I know I'm probably making this more difficult than it really is but I just cannot see the trees for the forest right now and your help is needed and much appreciated! Thanks! Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4834 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
