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.13 -r1.14 --- openacs-4/packages/acs-tcl/tcl/00-database-procs.tcl 30 Jul 2002 19:20:39 -0000 1.13 +++ openacs-4/packages/acs-tcl/tcl/00-database-procs.tcl 30 Jul 2002 19:59:50 -0000 1.14 @@ -298,7 +298,7 @@ } { Usage: db_list_of_ns_sets statement-name sql [ -bind bind_set_id | -bind bind_value_list ] - Returns a list of ns_sets with the values of each column of each row +

Returns a list of ns_sets with the values of each column of each row returned by the sql query specified. @param statement_name The name of the query. @@ -325,14 +325,14 @@ proc_doc db_foreach { statement_name sql args } { Usage: -

-    db_foreach statement-name sql [ -bind bind_set_id | -bind bind_value_list ] \
+    
+ 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 ] -
+ - Performs the SQL query sql, executing +

Performs the SQL query sql, executing code_block once for each row with variables set to column values (or a set or array populated if -column_array or column_set is specified). If the query returns no rows, executes @@ -447,15 +447,14 @@ args } { Usage: -

-    
-    db_multirow [ -local ] [ -append ] [ -extend column_list ] \
+    
+ 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 ] -
+ - Performs the SQL query sql, saving results in variables +

Performs the SQL query sql, saving results in variables of the form var_name:1, var_name:2, etc, setting var_name:rowcount to the total number @@ -650,13 +649,13 @@ ad_proc db_0or1row { statement_name sql args } { Usage: -

-    
-    db_0or1row statement-name sql [ -bind bind_set_id | -bind bind_value_list ] \
+    
+ db_0or1row statement-name sql [ -bind bind_set_id | -bind bind_value_list ] \ [ -column_array array_name | -column_set set_name ] -
- Performs the SQL query sql. If a row is returned, sets variables + + +

Performs the SQL query sql. If a row is returned, sets variables to column values (or a set or array populated if -column_array or column_set is specified) and returns 1. If no rows are returned, returns 0. If more than one row is returned, throws an error. @@ -706,13 +705,13 @@ ad_proc db_1row { args } { Usage: -

-    
-    db_1row statement-name sql [ -bind bind_set_id | -bind bind_value_list ] \
+    
+ db_1row statement-name sql [ -bind bind_set_id | -bind bind_value_list ] \ [ -column_array array_name | -column_set set_name ] -
- Performs the SQL query sql. If a row is returned, sets variables + + +

Performs the SQL query sql. If a row is returned, sets variables to column values (or a set or array populated if -column_array or column_set is specified). If no rows are returned, throws an error.