Forum OpenACS Q&A: Response to Using multirow data source in form template

Collapse
Posted by Andrei Popov on
Ok, a bit more tinkering/RTFMing and the correct thing to do is:
set category [
    db_list category_qry {
        select option_name
        from params
        where param_id='category'
    }
]

form create test_form

element create test_form category 
        -label "Category" 
        -datatype text -widget select 
        -options $category