Re: Distinct counts with C::D::P::AbstractSearch or C::D::P::CountSearch

[prev] [thread] [next] [Date index for 2005/04/20]

CDBI::P::CountSearch is based on the search() code in CDBI and wont do
distinct without some changes.  It shouldn't be too hard to copy and
change the CDBI::P::CountSearch code to handle it though.  Change the
set_sql() call near the beginning of import() to include a distinct
clause (DISTINCT ON (%s)) and then change the _do_count_search code to
take another argument to plug into the %s.

Todd

On 4/20/05, Kevin Old <kevinold@xxxxx.xxx> wrote:
> Hello everyone,
>=20
> I was wondering if anyone knew of a way to get C::D::P::AbstractSearch
> or C::D::P::CountSearch to be distinct?
>=20
> Thanks,
> Kevin
> --
> Kevin Old
> kevinold@xxxxx.xxx
>=20
--
Todd Holbrook
Systems Consultant
Simon Fraser University