acs::db::nsdbi method list_of_lists (public)

 <instance of acs::db::nsdbi> list_of_lists [ -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 consists of a list of the column values corresponding to the 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)

not used for NSDBI, providing interface compatibility with NSDB

Parameters:

qn (required)

name of the SQL query

sql (required)

SQL query

Testcases:

No testcase defined.

Source code:

if {$sql eq ""} {
    set sql [:get_sql $qn]
}
set dbn [:map_default_dbn $dbn]
return [:uplevel [list ::dbi_rows  {*}[expr {$dbn ne "" ? [list -db $dbn] : ""}]  {*}[expr {$bind ne "" ? [list -bind $bind] : ""}]  -result lists -max 1000000 -- $sql]]

XQL Not present:

Generic, PostgreSQL, Oracle