It's stuff like this that makes me glad I use PegasusMail at home. It's not subject to these things.
> -----Original Message----- > From: jon roig [mailto:[EMAIL PROTECTED]] > Sent: Friday, July 12, 2002 10:26 AM > To: CF-Talk > Subject: RE: Tracking Emails > > > This is how we track readership: > > * First, we have a 1x1 transparent gif file in our images > folder. * Second, when I send out a newsletter, I give it a > tracking code... > * Third, the actual tool I send the newsletters with converts > a little code > ||EMAIL|| to the user's email address. Buried in the HTML of the > ||EMAIL|| newsletter, > I've got a little bit of code that says: > > <img > src="http://www.epilepsyfoundation.org/images/enewsletter.cfm? > issue=advocacy > _may_2002&emailaddress=||EMAIL||"> > > > The actual CF code on the backend looks like this: > > > ---------------------------- > > <!--- this is a small tool to determine readership of the > enewsletter. written by Jon Roig ([EMAIL PROTECTED]) ---> > <cfparam name="emailAddress" default="none"> <cfparam > name="issue" default="unknown"> > > <Cfquery name="logUser" datasource="content" dbtype="OLEDB"> > INSERT INTO dbo.eNewsletterReaders (emailaddress, issue, > ipAddress) VALUES ('#emailAddress#', '#issue#', > '#CGI.REMOTE_ADDR#') </CFQUERY> > > <CFCONTENT type="image/gif" FILE="c:\newsite\images\1pwhite.gif" > DELETEFILE="No" > > > ---------------------------- > > Of course, the caveat here is that this is nowhere near 100% > accurate. Some email clients don't load the gifs but display > the HTML -- AOL 5 comes to mind. It does give us a rough idea > of whats up, nonetheless. > > -- jon > > > > -----Original Message----- > From: Jim Gurfein [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 11, 2002 7:57 PM > To: CF-Talk > Subject: Tracking Emails > > > Hey, list... > > Does anyone have an easy way to create a database record when > an email is opened? > > We can embed a gif and have it recorded in the logfiles, but > I'd like to somehow cause a post to a page ( and record it in > the database) when the email is opened. > > Thanks for the help. > > Jim > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
