OK, imaging you have a column in your DB which contains all of your message content and within that message content you have [firstname] and [lastname] in it; you could do the following...(pseudo code)
// This will get the message data <cfquery> Select messagectontent from message Where messageid =1 </cfquery // this does the replacing <cfset MessageTextAmended = ReplaceNoCase(messagectontent, "[firstname]", "John Smith", "All")> The variable MessageTextAmended now should contain John Smith in place of the placeholder [firstname] You could do this an infinite amount of times per placeholder/variable. You could of course replace "John Smith" with a DB variables. Make sense? N -----Original Message----- From: Nick Sweeney [mailto:[EMAIL PROTECTED] Sent: 25 October 2005 15:45 To: CF-Newbie Subject: RE: CFMail Functionality I understand and yet don't understand. How do you "replace" the data? Where and when? I get the concept but don't know the nuts and bolts of how... Thanks, -Nick -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 25, 2005 9:20 AM To: CF-Newbie Subject: RE: CFMail Functionality Yes it is possible and lots of example out there... A common approach is to have the following kind of thing within your message [fist name][last name] And then replacing these with real data . We built a mail tool which can do this (around 50 personal fields), it can also track emails etc such as who opened it, what links they clicked on etc ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1481 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
