Probably the right thing to do is to fix the SQL query--look at the 'DISTINCT' option on the SELECT is probably what you want. On Sat, 3 Jan 2004, garry saddington wrote:
I have a dtml method that accepts input from a zsql method and dtml-in is used to loop over the result set. However, there are duplicate values in the query result set(by design) but i want to list only one iteration of each value in my dtml method. Does anyone know how to do this, ie skip over duplicate results? regards garry
_______________________________________________ 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 )