Print Page | Close Window

SQL Help

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=4686
Printed Date: 13 August 2025 at 7:37pm


Topic: SQL Help
Posted By: kspare
Subject: SQL Help
Date Posted: 03 December 2004 at 10:23am
I am trying to write a script to delete spam caught with file attachements. I came up with this so far...

update tblquarantine set expire=1 where RejectDetails = 'Found Keywords: [Found prohibited attachment:'

But it doesn't work. Can anyone help?


Replies:
Posted By: Desperado
Date Posted: 03 December 2004 at 11:59am

See Post Below

Regards,

Dan S.

Posted By: Desperado
Date Posted: 03 December 2004 at 12:18pm
OK ... This will find them:
 
select * from tblquarantine
where rejectid = 13
and rejectdetails like '%attach%'
 
This will delete them:
 
update tblquarantine set expire=1
where rejectid = 13
and rejectdetails like '%attach%'
 
Regards,
 
Dan S.

Posted By: kspare
Date Posted: 03 December 2004 at 12:30pm
Thanks Dan!!! Worked perfectly!

Posted By: Desperado
Date Posted: 03 December 2004 at 12:31pm

Good Deal!

Dan


Print Page | Close Window