Michel Combe wrote at 2003-2-3 15:32 +0100:
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... Look at the "first-xxx" variable defined by "dtml-in".
You can read something about it in <http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html> Other places: the "DTML reference" in the embedded online help, and the appendix of the Zope book. Dieter