Use an SQL query as below, then call it from a Python script, located within acquisition context, such as --- rv = [] for row in old_zsql_method: rv.append(row.field1) return rv --- Then give the name of your Python script as the default value of the "multiple" property. Dustin On Mon, Sep 01, 2003 at 06:06:32PM -0500, Daniel Ajoy wrote:
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
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
-- Dustin Mitchell dustin@ywlcs.org/djmitche@alumni.uchicago.edu http://people.cs.uchicago.edu/~dustin/ PGP Key: http://people.cs.uchicago.edu/~dustin/pubkey.txt