Re: SQL Question -- FIX

2005-05-14 Thread Michael Parker
On Fri, May 13, 2005 at 06:53:28PM -0700, Steven Manross wrote: > ***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

RE: SQL Question -- FIX

2005-05-13 Thread Steven Manross
***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

Re: SQL Question

2005-05-13 Thread Daryl C. W. O'Shea
Michael Parker wrote: debug: bayes: tok_get_all: Token Count: 302 debug: bayes: tok_get_all: SQL Error: [Microsoft][ODBC SQL Server Driver][SQL Se rver]'RPAD' is not a recognized function name. (SQL-42000) [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepare d. (SQL-4200

RE: SQL Question

2005-05-13 Thread Steven Manross
arker [mailto:[EMAIL PROTECTED] Sent: Friday, May 13, 2005 12:38 PM To: Steven Manross Cc: users@spamassassin.apache.org Subject: Re: SQL Question > debug: bayes: tok_get_all: Token Count: 302 > debug: bayes: tok_get_all: SQL Error: [Microsoft][ODBC SQL Server Driver][SQL Se > rver]'RPAD&

Re: SQL Question

2005-05-13 Thread Michael Parker
> debug: bayes: tok_get_all: Token Count: 302 > debug: bayes: tok_get_all: SQL Error: [Microsoft][ODBC SQL Server Driver][SQL > Se > rver]'RPAD' is not a recognized function name. (SQL-42000) > [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be > prepare > d. (SQL-42000)(DBD

RE: SQL Question

2005-05-13 Thread Steven Manross
Friday, May 13, 2005 8:57 AM To: Steven Manross Cc: users@spamassassin.apache.org Subject: Re: SQL Question On Fri, May 13, 2005 at 08:35:08AM -0700, Steven Manross wrote: > On that same note, > > I was playing around with BAYES on a MS SQL Server... > (I followed the directions in the r

Re: SQL Question

2005-05-13 Thread Michael Parker
On Fri, May 13, 2005 at 08:35:08AM -0700, Steven Manross wrote: > On that same note, > > I was playing around with BAYES on a MS SQL Server... > (I followed the directions in the readme files and tweaked the mysql.sql > code to work for MS SQL in creation of the tables.) Ahhh, most excellent, I d

RE: SQL Question

2005-05-13 Thread Steven Manross
nks, Steven -Original Message- From: Michael Parker [mailto:[EMAIL PROTECTED] Sent: Thursday, May 12, 2005 10:11 AM To: users@spamassassin.apache.org Subject: Re: SQL Question On Thu, May 12, 2005 at 05:47:26PM +0100, Alan Munday wrote: > > Thanks, though I can't seem to find

Re: SQL Question

2005-05-12 Thread Alan Munday
Kevin Peuhkurinen wrote the following on 12/05/2005 18:12: Actually, scratch that. Those are not the documents I was thinking they were.Instead, download the latest copy of SA and you will find a folder in the distribution called "sql". In there, there is some README files that describe ho

Re: SQL Question

2005-05-12 Thread Kevin Peuhkurinen
Kevin Peuhkurinen wrote: Look at http://spamassassin.apache.org/full/3.0.x/dist/doc/ for file names that end in SQL. Kevin Actually, scratch that. Those are not the documents I was thinking they were.Instead, download the latest copy of SA and you will find a folder in the distribution cal

Re: SQL Question

2005-05-12 Thread Michael Parker
On Thu, May 12, 2005 at 05:47:26PM +0100, Alan Munday wrote: > > Thanks, though I can't seem to find the Docs that cover bayes/AWL setup on > the Wiki or apache site. > > Are there any docs that are considered definitive around? > sql/README.bayes sql/README.awl is the definitive documentation

Re: SQL Question

2005-05-12 Thread Alan Munday
Kevin Peuhkurinen wrote the following on 12/05/2005 18:03: Alan Munday wrote: Look at http://spamassassin.apache.org/full/3.0.x/dist/doc/ for file names that end in SQL. Kevin Thanks, they did not come up when googling. Alan

Re: SQL Question

2005-05-12 Thread Kevin Peuhkurinen
Alan Munday wrote: Thanks, though I can't seem to find the Docs that cover bayes/AWL setup on the Wiki or apache site. Are there any docs that are considered definitive around? Look at http://spamassassin.apache.org/full/3.0.x/dist/doc/ for file names that end in SQL. Kevin

Re: SQL Question

2005-05-12 Thread Alan Munday
Michael Parker wrote the following on 12/05/2005 17:37: On Thu, May 12, 2005 at 05:16:19PM +0100, Alan Munday wrote: I've been looking through the SA SQL docs and can only see references to spamc/spamd use of SQL. Can I just confirm that SQL can be used with spamassassin as well? Only for Bayes

Re: SQL Question

2005-05-12 Thread Michael Parker
On Thu, May 12, 2005 at 05:16:19PM +0100, Alan Munday wrote: > > I've been looking through the SA SQL docs and can only see references to > spamc/spamd use of SQL. > > Can I just confirm that SQL can be used with spamassassin as well? Only for Bayes and AWL, userprefs in SQL requires the use of