xo::db::DB-postgresql instproc multirow (public)

 <instance of xo::db::DB-postgresql[i]> multirow [ -dbn dbn ] \
    [ -bind bind ] [ -local local ] [ -upvar_level upvar_level ] \
    [ -extend extend ] [ -prepare prepare ] var_name qn sql [ body ]

Defined in /var/www/openacs/packages/xotcl-core/tcl/05-db-procs.tcl

Append query results to a template multirow, creating it if needed.

Switches:
-dbn (optional)
Database name, or empty for the default.
-bind (optional)
Bind values for the query.
-local (optional, defaults to "false")
Keep the multirow local to the selected caller frame.
-upvar_level (optional, defaults to "1")
Caller level at which to store the multirow.
-extend (optional)
Additional column names to populate in the row body.
-prepare (optional)
Optional argument types for a prepared statement.
Parameters:
var_name (required)
Template multirow name.
qn (required)
Query name.
sql (required)
SQL statement.
body (optional)
Optional Tcl script to run for each row.

Testcases:
test_prepared_statements, test_multirow, test_db_out_of_pools
[ show source ]
Show another procedure: