[dev] getByAttributes and buildAttributeQuery patch

Duck duck at obala.net
Tue Aug 31 02:09:49 PDT 2004


On Tuesday 31 of August 2004 03:01, Chuck Hagenbuch wrote:
> Quoting Duck <duck at obala.net>:
> > Allows limiting the result of join getByAttributes and adds a GROUP BY
> > statement to the sql query returned from buildAttributeQuery, becouse it
> > doubles the data returned from sql.
>
> This patch contains your previous patch and debugging output. Also, are
> both the
> GROUP BY and the DISTINCT needed? Or is the DISTINCT left over from
> debugging attempts?
>
> -chuck
>
> --
> "Regard my poor demoralized mule!" - Juan Valdez

sorry.
DISTINCT is not needed.
the GROUP BY shuold be used, becouse it affects COUNT() too.

Duck


More information about the dev mailing list