[Zope] how to skip duplicate zsql results?

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