Here's the PATCH.... On Monday 14 July 2008 14:06:00 Kris Groves wrote: > Hi, > > Here's the path for the 'select distinct' problem. It's a patch against > the cvs version. However, I coded it against 0.8.3-1 release. If there's > any problems, let me know. > > Also, I think I should point out that there are a couple of caveats when > using the sqlite3 driver, that I have mentioned in the code comments, but > should also be mentioned in the driver documentation. > > 1. When using a function as a result column (e.g. count(*) ), the opening > bracket MUST hug the function name. The function call MUST also be > aliased. > > 2. When using am expression as a result column (e.g. count(*) + 6 ), the > entire expression MUST be enclosed in brackets and MUST be aliased. > > Simple enough.
-- Kris Groves Project Manager / Software Engineer mm-lab GmbH Phone: +49 7154 827 323 Stammheimer Str. 10 Fax: +49 7154 827 350 D-70806 Kornwestheim [EMAIL PROTECTED] www.mmlab.de Domicile of Company: Kornwestheim, Germany District Court - Court of Registration Stuttgart HRB 207257 Managing Directors: Bernd Herrmann, Lothar Krank, Michael Meiser, Dr. Andreas Streit ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ Libdbi-drivers-devel mailing list Libdbi-drivers-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel