RE: [Dbmail] diff between 1.x and 2.x and other questions

2003-11-05 Thread Chris Carter
MySQL just does not support some features: "SELECT Max(people.version) AS Lastversion, addr.name FROM people RIGHT JOIN addr ON people.ID = addr.ID GROUP BY addr.name;" Will not work in Mysql; this sql statement I used in M$SQLServer required creating a temporary table in Mysql and then running an

Re: [Dbmail] DBMail: diff between 1.x and 2.x and other questions

2003-11-05 Thread Christian G. Warden
On Wed, Nov 05, 2003 at 10:54:47PM +0100, Chris Carter wrote: > > Hmmm ADODB? That way someone else maintians compability. > > Query statements are potentially still different between SQL server > platforms. ADODB handles many such differences in SQL syntax. It has syntax for CONCAT, SUBS

Re: [Dbmail] DBMail: diff between 1.x and 2.x and other questions

2003-11-05 Thread Eric Soroos
I have used Evolution, Outlook Express, Mozilla, Thunderbird and to a lesser extent Outlook. They all work well. To me the main reason to use dbmail is for IMAP. Traditional unix based imap servers really hit a performance wall when mailboxes start getting big. dbmail is MUCH better. I hav

RE: [Dbmail] diff between 1.x and 2.x and other questions

2003-11-05 Thread Ted Rolle
It IS possible to write code that requires a one-statement change to run on PostgreSQL or MySQL. However, ADODB adds overhead of its own. Whatever...

RE: [Dbmail] DBMail: diff between 1.x and 2.x and other questions

2003-11-05 Thread Chris Carter
> Hmmm ADODB? That way someone else maintians compability. Query statements are potentially still different between SQL server platforms. Cheers! Chris

Re: [Dbmail] DBMail: diff between 1.x and 2.x and other questions

2003-11-05 Thread Ted Rolle
> The database code has been reorganized to separate MySQL and > PostgreSQL-specific code from common database access code. Hmmm ADODB? That way someone else maintians compability. Ted

Re: [Dbmail] DBMail: diff between 1.x and 2.x and other questions

2003-11-05 Thread Matthew T. O'Connor
Christian G. Warden wrote: On Wed, Nov 05, 2003 at 08:04:02PM +0100, Chris Carter wrote: 3. How does DBMail's IMAP support compare to other packages? Does M$Lookout work? Can I use Ximian Evolution? Or Kmail? I presume that POP works just fine (but I am interested in IMAP). I've only

Re: [Dbmail] DBMail: diff between 1.x and 2.x and other questions

2003-11-05 Thread Christian G. Warden
On Wed, Nov 05, 2003 at 08:59:49PM +0100, Chris Carter wrote: > Ryan thanks for your help. To be very honest I did scroll through the > mail archive, but I couldn't find any 'search' feature and I gave up > after reading all mails (one by one) in Nov and Oct (and I didn't want > to download 20MB).

RE: [Dbmail] DBMail: diff between 1.x and 2.x and other questions

2003-11-05 Thread Chris Carter
Ryan thanks for your help. To be very honest I did scroll through the mail archive, but I couldn't find any 'search' feature and I gave up after reading all mails (one by one) in Nov and Oct (and I didn't want to download 20MB). The answers received (Christian's and yours) have answered my questio

Re: [Dbmail] DBMail: diff between 1.x and 2.x and other questions

2003-11-05 Thread Ryan Butler
On Wed, 2003-11-05 at 13:04, Chris Carter wrote: > Hi, > > I would like to ask some questions which I have not been able to find > answers for. I admit I have not installed DBMail but I did see the site > and the README files in the source code. > > 1. What are the differences between 1.x version

Re: [Dbmail] DBMail: diff between 1.x and 2.x and other questions

2003-11-05 Thread Christian G. Warden
On Wed, Nov 05, 2003 at 08:04:02PM +0100, Chris Carter wrote: > Hi, > > I would like to ask some questions which I have not been able to find > answers for. I admit I have not installed DBMail but I did see the site > and the README files in the source code. > > 1. What are the differences betwee

[Dbmail] DBMail: diff between 1.x and 2.x and other questions

2003-11-05 Thread Chris Carter
Hi, I would like to ask some questions which I have not been able to find answers for. I admit I have not installed DBMail but I did see the site and the README files in the source code. 1. What are the differences between 1.x versions and the new 2.0 alpha1? 2. I finally twigged that DBMail does