***This now works (with minor mods to the SA distro files [SQL.pm] and
the creation of an additional MS SQL User defined function)

I've mocked up an MS SQL Version of RPAD that could be easily introduced
into the readme code that creates the bayes tables, and sets the
version. (please correct the SQL for RPAD if I've incorrectly defined
part of it). 

spamassassin -D <input.txt >output.txt

...showed bayes activity and marked spam/ham accordingly.

The only problem now being is that when you call MS SQL RPAD, you need
to do so, like so:

dbo.RPAD('this',5,' ')

Noting the only change necessary being to prepend "dbo." to the function
name in the:

Mail\SpamAssassin\BayesStore\SQL.pm

file.

Thanks be to both Michael Parker and Daryl O'Shea for their help.

How would I get this kind of suggestion considered for implementation in
a future release/or just even in the docs?  Through bugzilla?

Thanks to all involved in SA..  I've been using SA for a couple years
now, and it's a truly remarkable piece of work!

Thanks,
Steven

Attachment: bayes_mssql.sql
Description: bayes_mssql.sql

Reply via email to