[Zope-dev] ZCatalog & distinct in SQL

Casey Duncan casey_duncan@yahoo.com
Fri, 23 Feb 2001 08:33:02 -0800 (PST)


--- Valérie Aulnette <vaulnette@yahoo.fr> wrote:
> Hi, 
> 
> I am using PTK and it does work with ZCatalog.
> I need to do the list of values that are in the
> catalog  but I need do do like a "select distinct"
> in
> SQL to have each value only once.
> Do you know how to do that in ZCatalog ?
> 
> Thanks.
> Valerie.
> 
>

For fieldindexes there is a catalog method
uniqueValuesFor(name) which when passed the name of
the index returns the unique values within it.

hth,

=====
| Casey Duncan
| Kaivo, Inc.
| cduncan@kaivo.com
`----------------->

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/