[Zope] how to skip duplicate zsql results?

Wayne Connolly wayne@c-media.com.au
Tue, 29 Jul 2003 21:00:04 -0700 (PDT)


i have a simple zsql (select * from table) which
returns a list of items.

The problem is that it returns identical items. Ie
1. item 1
2. item 1
3. item 2

How can i make it skip/omit the second duplicate
entry. Below is the code.

<SELECT name="item">
<OPTION tal:repeat="table here/getTableMethod"><SPAN
tal:replace="table/item">Some Item</SPAN></OPTION>
        </SELECT>

Thanks,
Wayne

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com