[Zope] Newbie needs help

[Schmidt, Allen J.]

SELECT DISTINCT supplier FROM supplier_table ORDER BY supplier

-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
Michel Combe
Sent: Monday, February 03, 2003 9:32 AM
To: Zope@zope.org
Subject: [Zope] Newbie needs help


Hi,

What I want to do is display, from the result of an SQL query, each first
occurence of a supplier name .
ie : I have a query which returns for example "s1,s1,s1,s2,s2,s3,s3" and I
want to display "s1,s2,s3".

This is what I wrote :
<dtml-let previous="''">
<dtml-in SQL_SelectSupplier>
  <dtml-if "SupplierName!=previous">
    <p>Found First</p>
  <dtml-else>
    <p>Found Next</p>
    <dtml-let previous=SupplierName></dtml-let>
  </dtml-if>
<dtml-in>

It doesn't work and I can't find why...
Thanks for your help

Michel Combe




_______________________________________________
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 )