SQL Help |
Post Reply 
|
| Author | |
kspare 
Senior Member 
Joined: 26 January 2005 Location: Canada Status: Offline Points: 334 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: SQL HelpPosted: 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?
|
|
 |
|
|
Desperado
Senior Member
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
Posted: 03 December 2004 at 11:59am |
|
See Post Below Regards, Dan S. |
|
|
|
|
Desperado
Senior Member
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
kspare
Senior Member
Joined: 26 January 2005 Location: Canada Status: Offline Points: 334 |
Post Options
Thanks(0)
Quote Reply
Posted: 03 December 2004 at 12:30pm |
|
Thanks Dan!!! Worked perfectly!
|
|
|
|
|
Desperado
Senior Member
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
Posted: 03 December 2004 at 12:31pm |
|
Good Deal! Dan |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.230 seconds.