Actually, I've got something even better to clean out a persons mail box. It's fast, safe and 100% effective. I'll have it up in FA as soon as Judith edits it (it's at the top of her list). I'm having fun with this virus. The patterns in its headers are so simple....
> I'd recommend creating a 2nd table to hold subject strings and using it for comparison instead of the chain of or's... > > SELECT distinct spam.Subject > FROM Spam, spam_headers > WHERE spam.DomainChecked = 0 > AND spam.subject like '%' + spam_headers.subject + '%' > > other than that not a bad idea. :) > > ------ Original Message ------ > From: [EMAIL PROTECTED] (Michael Dinowitz) > To: CF-Community <[EMAIL PROTECTED]> > Sent: Aug 20, 2003 11:21 AM > Subject: Re: Clean off > > >I'm assuming everyone is covered by spam at the moment can can't post. If so, > >how about using CF to do your cleanup for you. Use CFPOP to get all the headers > >from your mail box (or maybe the first 20-50 at a time) and then run this > >against the returned query: > >SELECT Subject > >FROM Spam > >WHERE (DomainChecked = 0) AND (Subject LIKE '%Thank you%' OR > > Subject LIKE '%Approved%' OR > > Subject LIKE '%Details%' OR > > Subject LIKE '%Wicked screensaver%' OR > > Subject LIKE '%movie%' OR > > Subject LIKE '%your application%' OR > > Subject LIKE '%attachment%' OR > > Subject LIKE '%failure%' OR > > Subject LIKE '%failed%' OR > > Subject LIKE '%returned%' OR > > Subject LIKE '%virus%') > >ORDER BY Subject > >Anything that comes back can be routed to the screen so you can view the subject > >and other info. If its spam, just tell CFPOP to delete it. Saves on the > >downloading and can even be automated more. > >If you have access to your mail server, I've got an additional script suggestion > >that'll do the job automatically by detecting any mail files with viruses in > >them. Just needs CF, CFDIRECTORY, a CFX and a CFIF. > > > >Michael Dinowitz > >Finding technical solutions to the problems you didn't know you had yet > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:5 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
