ad_db_select_widget (public, deprecated)

 ad_db_select_widget [ -size size ] [ -multiple multiple ] \
    [ -default default ] [ -option_list option_list ] \
    [ -blank_if_no_db blank_if_no_db ] \
    [ -hidden_if_one_db hidden_if_one_db ] [ -bind bind ] \
    statement_name sql_qry name

Defined in packages/acs-tcl/tcl/widgets-procs.tcl

Deprecated. Invoking this procedure generates a warning.

given a SQL query this generates a select group. If there is only one value it returns the text and a hidden variable setting that value. The first selected column should contain the optionlist items. The second selected column should contain the optionlist values.

option_list is a list in the same format (i.e. {{str val} {str2 val2}...}) which is prepended to the list

if sql_qry is null then the list is constructed from option_list only.

if there is only one item the select is not generated and the value is passed in hidden form variable.

if -multiple is given then a multi select is returned.

if -blank_if_no_db is true, then do not return a select widget unless there are rows from the database DEPRECATED: the template system offers better ways to produce markup from a query nowadays.

Switches:

-size (optional, defaults to "0")

-multiple (optional, defaults to "0")

-default (optional)

-option_list (optional)

-blank_if_no_db (optional, defaults to "0")

-hidden_if_one_db (optional, defaults to "0")

-bind (optional)

Parameters:

statement_name (required)

sql_qry (required)

name (required)

See Also:

• template::widget::select
• template::widget::multiselect
• /doc/acs-templating/tagref/multiple

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.