Forum OpenACS Q&A: Re: Combo box with the data from db

I would assume that the form proc doesn't work because {$query_sub} is within curly braces and that is not evaluated and substed by the form proc. If you remove the curly braces around $query_sup that might do it... If that doesn't do it, this should work:

set query_sup [db_list_of_lists sup_loop "select sup_fullname, sup_id from rpt_supervisor"]

ad_form create -name "add_project" -form {
   {project_sub:text(select) {label "Supervisor"} {options $query_sup}}
} -on_request {
} -on_submit {
}