xo::db::DB-postgresql instproc multirow (public)
<instance of xo::db::DB-postgresql> 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
![[i]](/resources/acs-subsite/ZoomIn16.gif)