Hi, You need to put form/getProvinces in the TALES->Items field. Also, please note that Formulator Items are a list with each item like (displayed value, option value). So, if your query is select code, name from provinces, the form field generated will be like <option value="name">code</option> which may not be what you need; (if you do want to go back to the datbase with code; you want the form to be like <option value="code>name</option>) So, you might want to make your query like select name, code from provinces. - Babu http://vsbabu.org/ CLIFFORD ILKAY wrote:

Hi,

I would like to bind the result of the following SQL query to a Formulator dropdown list.

select code, name from provinces;

How would I do that?

Regards,

Clifford Ilkay Dinamis Corporation 3266 Yonge Street, Suite 1419 Toronto, Ontario Canada M4N 3P6

Tel: 416-410-3326

_______________________________________________ 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 )