Prevent Form Spam with SpamFilter.cfc
I was told last week that a client's contact form has been getting a lot of spam - on the order of 30 a day. We had a simple spam prevention measure in place, but that clearly wasn't doing the job. It was time for something a little more sophisticated.
That makes sense. My worry about such a technique is that the referrer is actually pretty easy to spoof. It seems like only a matter of time until that approach would quit working.
Here are the debug query I got from submitting the form:
SELECT Table_Name FROM INFORMATION_SCHEMA.TABLES WHERE Table_Type = 'BASE TABLE' AND Table_Name <> 'dtproperties'
SELECT TOP 1 * FROM [spamWords]
SELECT [spamRegExs].[RegExID] , [spamRegExs].[RegEx] , [spamRegExs].[Label] , [spamRegExs].[points] FROM [spamRegExs] WHERE 1 = 1
SELECT [spamWords].[WordID] , [spamWords].[Word] , [spamWords].[points] FROM [spamWords] WHERE 1 = 1
Last 3 query looped several times. Please advice.
Thanks,
Bill
Sounds like it isn't working right. Want to send me an email ("steve" at the domain name from which you downloaded the component)? Then we can work through the problem and I can get the component fixed and updated.
Thanks
Is that not what is supposed to happen? If everything is spam, then I have nothing to respond to.
Just kidding, of course. I found and fixed the problem and uploaded a new zip of SpamFilter.cfc with the fix.
Thanks for taking the time to report the problem so that I could address it.