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 another query from the temporary one to get the answer (not sure about PostgreSQL). ADODB is a wonderful tool (use it all the time), but I think it does not write SQL statements (yet). Cheers! Chris > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ted Rolle > Sent: 05 November 2003 23:35 > To: Dbmail mailing list > Subject: RE: [Dbmail] diff between 1.x and 2.x and other questions > > > 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... > _______________________________________________ > Dbmail mailing list > [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail >
