acs::db::nsdb method list (public)

 <instance of acs::db::nsdb> list [ -dbn dbn ] [ -bind bind ] \
    [ -prepare prepare ] qn sql

Defined in packages/acs-tcl/tcl/acs-db-00-procs.tcl

Return a Tcl list, where each element contains just the first the column values of the tuples returned by the provided SQL query.

Switches:

-dbn (optional)

database identifier

-bind (optional)

optional bind variables for the SQL query

-prepare (optional)

type information for the bind variables in the prepared statement

Parameters:

qn (required)

name of the SQL query

sql (required)

SQL query

Testcases:

No testcase defined.

Source code:

set bindOpt [expr {$bind ne "" ? [list -bind $bind] : ""}]
if {$sql eq ""} {
    set qn [uplevel [list [self] qn $qn]]
}
uplevel [list ::db_list -dbn [:map_default_dbn $dbn] $qn $sql {*}$bindOpt]

XQL Not present:

Generic, PostgreSQL, Oracle