3 Feb
2003
3 Feb
'03
3:01 p.m.
on or about, Monday, February 03, 2003, we have reason to believe that Michel Combe wrote something along the lines of :
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".
use a script(python) for things like this : suppliers = context.SQL_SelectSupplier() # pass parameters as needed ;) distincts = [] for i in suppliers: if not i.SupplierName in distincts: distincts.append(i.SupplierName) return distincts :) -- Geir Bækholt geir@funcom.com Web Application/HCI-designer Product Operations Funcom Oslo