[Zope] how to skip duplicate zsql results?

Andreas Jung Andreas Jung <andreas@andreas-jung.com>
Wed, 30 Jul 2003 06:11:03 +0200


isn't there a UNIQUE statement in SQL? Anyway...you should fix your SQL
your data in the database.

-aj

--On Dienstag, 29. Juli 2003 21:00 Uhr -0700 Wayne Connolly 
<wayne_connolly@yahoo.com> wrote:

> 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
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )