Why cant you just popluate the "ID" when you generate the email... if i understand your question correct.. Query... whatever <cfloop query....>
<cfmail .....> <cfif queryName.CustomerID eq "12"> #query.CustomerID# </cfif> </cfmail> </cfloop> You will have to evaluate and parse the field value.. if you put in it in DB.l Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -----Original Message----- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 12:25 PM To: CF-Talk Subject: Best solution for this Hi all, I am making some changes to one of our apps that our sales people use for emailing to customers. We have an interface that the sales people can use to create their own emails and get stored in a db, I need to allow the customerid that identifies the customer to be displayed in the body of the message, but only for one particular message. Is there a way to put my customerid into the form field that goes into the database and be able to grab the actual value of it when it sends out the email. Right now if I create a new email and put in #customerid# the email displays it exactly as that. I need to show the actual value that is there. Thanks, Ben Densmore Web Developer eSupport.com, Inc. (978) 686-6468 x333 http://www.esupport.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
