[Zope] feed ZSQL "select" to a multiple selection property

Daniel Ajoy dajoy at openworldlearning.org
Mon Sep 1 19:06:32 EDT 2003


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
> 




More information about the Zope mailing list