Webmaster Forum / ColdFusion / Getting Started / July 2006

Hi, I've been getting a lot of spam lately from my comments form. My comments
are stored in a DB. The problem is the spam keeps coming every day and
sometimes they come in tens and hundreds. This is really frustrating and
irritating. I am thinking of putting a CFQUERY on my application.cfm file that
searches for spam in my comments (basically, those entries that have lots of
<h1> and <http> and [url] words in them. And if there are such comments, they
are immediately deleted from my database.

Does anyone give an example how I can do this? Or does anyone have a better
solution to this?

Thanks! Any help is appreciated.