Spam Filter ISP Forums : Feature for the next new version? https://www.logsat.com/spamfilter/forums/ Wed, 12 Aug 2026 10:22:20 +0000 Fri, 03 Oct 2003 10:01:00 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=1912 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[Feature for the next new version? : Thanks ]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=2135&title=feature-for-the-next-new-version#2135 Author: Guests
Subject: 1912
Posted: 03 October 2003 at 10:01am

Thanks]]> Fri, 03 Oct 2003 10:01:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=2135&title=feature-for-the-next-new-version#2135 <![CDATA[Feature for the next new version? : Steve, That feature has been...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=2132&title=feature-for-the-next-new-version#2132 Author: LogSat
Subject: 1912
Posted: 03 October 2003 at 12:30am

Steve,

That feature has been added to the new 2.0 version that will hopefully be released in a month or two. It's not yet available in the 1.2.x builds.

Roberto F.
LogSat Software

]]> Fri, 03 Oct 2003 00:30:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=2132&title=feature-for-the-next-new-version#2132 <![CDATA[Feature for the next new version? : Hi Robert, Did you and your team...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=2129&title=feature-for-the-next-new-version#2129 Author: Guests
Subject: 1912
Posted: 02 October 2003 at 9:26pm

Hi Robert,

Did you and your team get a chance to include my request.

Thanks

]]> Thu, 02 Oct 2003 21:26:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=2129&title=feature-for-the-next-new-version#2129 <![CDATA[Feature for the next new version? : Daniel, I tend to agree with...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=1959&title=feature-for-the-next-new-version#1959 Author: Desperado
Subject: 1912
Posted: 12 September 2003 at 12:55am

Daniel,

I tend to agree with George below.  As to sorting, all that can be done in the ASP code. In you "ListSpam.asp" file, You can expand the sort options to any extent you want ...

Example:

 Select Case order_By
  Case "EmailTo"
   order_By = "EmailTo, MsgDate, Subject, EmailFrom, RejectDetails"
  Case "Subject"
   order_By = "Subject, MsgDate, EmailFrom, EmailTo, RejectDetails"
  Case "EmailFrom"
   order_By = "EmailFrom, MsgDate, EmailTo, Subject, RejectDetails"
  Case "Domain"
   order_By = "Domain, MsgDate, EmailTo, Subject, RejectDetails"
  Case "MsgDate"
   order_By = "MsgDate, EmailFrom, Subject, EmailTo, RejectDetails"
  Case "RejectDetails"
   order_By = "RejectDetails, MsgDate, EmailFrom, Subject, EmailTo"
  Case "DESC-MsgDate"
   order_By = "MsgDate DESC, EmailFrom, Subject, EmailTo, RejectDetails"
 End Select


Then, one query may look like the following ... NOTE the first line ... it sorts like you asked about:

 If (Field = "tofield") Then
  SQL = "SELECT SUBSTRING(EmailFrom, CHARINDEX('@', EmailFrom) + 1, 100) AS Domain, QuarID, EmailFrom, Subject, MsgDate, MsgID, RejectDesc,  RejectDetails, EmailTo "
  SQL = SQL & "FROM tblQuarantine, tblRejectCodes "
  SQL = SQL & "WHERE EmailTo LIKE '%" + Replace(SearchQuery, "'", "''") + "%' "
  SQL = SQL & "AND (Deliver <> 1) "
  SQL = SQL & "AND (Expire <> 1) "
  SQL = SQL & "AND (tblQuarantine.RejectID = tblRejectCodes.RejectID) "
  If SearchSpan = 1 Then
   SQL = SQL & "AND (MsgDate >= DATEADD(hour,-1,getdate())) "
  End If
  If SearchSpan = 4 Then
   SQL = SQL & "AND (MsgDate >= DATEADD(hour,-4,getdate())) "
  End If
  If SearchSpan = 8 Then
   SQL = SQL & "AND (MsgDate >= DATEADD(hour,-8,getdate())) "
  End If
  If SearchSpan = 24 Then
   SQL = SQL & "AND (MsgDate >= DATEADD(hour,-24,getdate())) "
  End If
  SQL = SQL & "ORDER BY " & order_By
  Set rs = con.Execute(SQL)
  RecordCount = rs.RecordCount
 End If


I have a lot more going on so this will not work directly in you code but you can get the idea.

Dan S.

]]> Fri, 12 Sep 2003 00:55:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=1959&title=feature-for-the-next-new-version#1959 <![CDATA[Feature for the next new version? : This is stuff that can be done...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=1955&title=feature-for-the-next-new-version#1955 Author: Guests
Subject: 1912
Posted: 11 September 2003 at 11:07pm

This is stuff that can be done through the web using a little asp code to make the queries. If SpamFilter keeps getting bigger due to all of the wish list items it is going to get more system intensive and the price for it is going to have go up due to the cost of addtional programming and development.

If I were to make a wish list add on it would be that all of the admin GUI be through the web. This would get around the issue of either having to use terminal services or some other third party remote access program. Since a good part of the program is using web/database already it wouldn't be too far off to go all the way and just make the service with out the gui or make it work both ways. Many of the current server applications for ISP's have web interfaces. Going with a web GUI will be a step in the right direction towards a multi-platform SpamFilter.

Just my two and a half cents worth.

 

g

]]> Thu, 11 Sep 2003 23:07:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=1955&title=feature-for-the-next-new-version#1955 <![CDATA[Feature for the next new version? : How about an option to sort quarantined...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=1948&title=feature-for-the-next-new-version#1948 Author: Guests
Subject: 1912
Posted: 11 September 2003 at 9:49am

How about an option to sort quarantined email by domain (after the @)]]> Thu, 11 Sep 2003 09:49:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=1948&title=feature-for-the-next-new-version#1948 <![CDATA[Feature for the next new version? : Okay, I did not know it was that...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=1933&title=feature-for-the-next-new-version#1933 Author: Guests
Subject: 1912
Posted: 10 September 2003 at 9:50am

Okay, I did not know it was that complicated of a change.

I will be watching for the next build.

Thanks

]]> Wed, 10 Sep 2003 09:50:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=1933&title=feature-for-the-next-new-version#1933 <![CDATA[Feature for the next new version? : Unfortunately that is not as simple...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=1929&title=feature-for-the-next-new-version#1929 Author: LogSat
Subject: 1912
Posted: 09 September 2003 at 6:38pm

Unfortunately that is not as simple as it seems. The "mail from" is checked as soon as the remote server sends the MAIL FROM command, before any data is sent. The "Reply-To" header is sent with the data, so the "mail from" filter does not know about the "Reply-to" header yet.

Changing the inner workings of this behavior is not something we want to undertake at the moment, so for now the most we can do is to have the regular keyword filter scan for that header.

Roberto

]]> Tue, 09 Sep 2003 18:38:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=1929&title=feature-for-the-next-new-version#1929 <![CDATA[Feature for the next new version? : Thanks Roberto. Instead of the...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=1928&title=feature-for-the-next-new-version#1928 Author: Guests
Subject: 1912
Posted: 09 September 2003 at 5:56pm

Thanks Roberto.

Instead of the keyword filter could you add it to the from-email filter?

Thanks again.

]]> Tue, 09 Sep 2003 17:56:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=1928&title=feature-for-the-next-new-version#1928 <![CDATA[Feature for the next new version? : Steve, Thanks for the request....]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=1926&title=feature-for-the-next-new-version#1926 Author: LogSat
Subject: 1912
Posted: 09 September 2003 at 5:50pm

Steve,

Thanks for the request. We can add it to the list of fields currently being checked by the existing keywords filter. That should be simple enough that we can probably include it in the next build to be released within a few days.

Roberto F.
LogSat Software

]]> Tue, 09 Sep 2003 17:50:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1912&PID=1926&title=feature-for-the-next-new-version#1926