db_list (public)

 db_list [ -dbn dbn ] [ -cache_key cache_key ] \
    [ -cache_pool cache_pool ] [ -subst subst ] statement_name sql \
    [ -bind bind ]

Defined in packages/acs-tcl/tcl/01-database-procs.tcl

Switches:

-dbn

(optional)

The database name to use. If empty_string, uses the default database.

-cache_key

(optional)

Cache the result using given value as the key. Default is to not cache.

-cache_pool

(defaults to "db_cache_pool") (optional)

Override the default db_cache_pool

-subst

(defaults to "all") (optional)

Perform Tcl substitution in xql-files. Possible values: all, none, vars, commands

-bind

(optional)

bind variables, passed either as an ns_set id, or via bind value list

Parameters:

statement_name
sql

Returns:

a Tcl list of the values in the first column of the result of SQL query sql. If sql doesn't return any rows, returns an empty list.

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

Testcases:

db__caching, db__list_variants