Index: openacs-4/packages/acs-tcl/tcl/00-database-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/Attic/00-database-procs.tcl,v diff -u -r1.14 -r1.15 --- openacs-4/packages/acs-tcl/tcl/00-database-procs.tcl 30 Jul 2002 19:59:50 -0000 1.14 +++ openacs-4/packages/acs-tcl/tcl/00-database-procs.tcl 30 Jul 2002 20:18:39 -0000 1.15 @@ -215,7 +215,7 @@ proc_doc db_string { statement_name sql args } { Usage: db_string statement-name sql [ -default default ] [ -bind bind_set_id | -bind bind_value_list ] - Returns the first column of the result of the SQL query $sql. +
Returns the first column of the result of the SQL query $sql. If the query doesn't return a row, returns $default (or raises an error if no $default is provided). } { @@ -240,7 +240,7 @@ proc_doc db_list { statement_name sql args } { Usage: db_list statement-name sql [ -bind bind_set_id | -bind bind_value_list ] - Returns a Tcl list of the values in the first column of the result of SQL query 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. Analogous to database_to_tcl_list. } { @@ -263,7 +263,7 @@ proc_doc db_list_of_lists { statement_name sql args } { Usage: db_list_of_lists statement-name sql [ -bind bind_set_id | -bind bind_value_list ] - Returns a Tcl list, each element of which is a list of all column +
Returns a Tcl list, each element of which is a list of all column values in a row of the result of the SQL querysql. If sql doesn't return any rows, returns an empty list. Analogous to database_to_tcl_list_list. @@ -328,7 +328,7 @@
db_foreach statement-name sql [ -bind bind_set_id | -bind bind_value_list ] \ [ -column_array array_name | -column_set set_name ] \ - code_block [ if_no_rows if_no_rows_block ] + code_block [ if_no_rows if_no_rows_block ]@@ -450,7 +450,7 @@
db_multirow [ -local ] [ -append ] [ -extend column_list ] \ var-name statement-name sql [ -bind bind_set_id | -bind bind_value_list ] \ - code_block [ if_no_rows if_no_rows_block ] + code_block [ if_no_rows if_no_rows_block ]