Killing Spam in VB5 - need sql help

[JWC]

Hey guys,

So I've been working on a tool that analyzes posts, urls in posts, sources etc and determines which posts are spam. So far it does a fantastic job of separating the spam from the ham, but I've run into a block.

I don't want to delete the post, I just want to make it invisible. In the DB (I'm doing this entirely outside of the VB codebase) I mark the post as "invisible = 2" which from other posts leads me to believe it would be invisible. When I return to the page - post is still there.

So - what am I missing? Is there another table I need to update? Is there an ajax call I can hit ti make the post invisible on it's own? This forum has hundreds of thousands of members and the spam, while not terrible, is dispersed throughout - so it's hard to clean it by hand.

Thanks!
-John