Re: Group by paramether in getSome()

On Sat, Jun 25, 2005 at 03:20:07AM +0200, Faber wrote:
> Every time I've to do a SELECT with GROUP BY statement I've to use the DBI's 
> execute() method... Perhaps an additional, optional paramether to getSome() 
> could be useful to others?

You can use fetch() for this.  There isn't any reason to use
execute(), I don't think, now that you have fetch().

I suppose it would be possible to add a parameter, "group", to
getSome(), since it is a sql keyword and couldn't be a column name.
But would it be that useful, given that the result set in getSome() is
fixed and can't contain aggregates?  Could you give an example of a
query that you want to run with getSome() that has a group by clause?

js

   


-- 
Jacob Smullyan

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFCvMCouqamFyFXXLIRAoOsAJ4oO4Zr9dGjpQQ+zEPDRrZOux8pwwCeKxq3
AvTNKdj7Fy4MAOZmI6ERGMQ=
=iYc5
-----END PGP SIGNATURE-----