Thanks but what I need is the opposite. I what the result of this: select field1 from table order by field1 be the posible values of a property of type "multiple selection" of an object. Daniel On 1 Sep 2003 at 13:30, David Hassalevris wrote:
Daniel, Here is a snippet from some old zsql method. --------------- code -------------------------------------------------------- select segment3,segment4, description from COA_DETAIL where postflag = 1 and base_acct_type_id = 4 and <dtml-sqltest accounts column="segment3" type="string" op="eq" multiple> order by segment3,segment4
Notes: . accounts is a list. In the parameters section I used accounts:list. . I could not get this to work using zSql TEST. Try it from a method. --------------------------------------------------------------------------- ----- David