[ Michel Combe]
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
You have gotten some solutions but they have not answered the part 'I can't find out why...'. The reason is that assignments made using dtml-let only exist within the scope of that dtml-let. IOW, they are not assigned to the whole page but only to that part of the code. Your second assignment to "previous" will not change the earlier definition of "previous". Cheers, Tom P