Index: openacs-4/packages/acs-tcl/tcl/01-database-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/Attic/01-database-procs.tcl,v
diff -u -r1.1.2.24 -r1.1.2.25
--- openacs-4/packages/acs-tcl/tcl/01-database-procs.tcl 27 Feb 2021 17:48:35 -0000 1.1.2.24
+++ openacs-4/packages/acs-tcl/tcl/01-database-procs.tcl 27 Feb 2021 22:25:31 -0000 1.1.2.25
@@ -1361,23 +1361,22 @@
{-subst all}
statement_name
sql
- args
+ -default
+ -bind
} {
- Usage: db_string statement-name sql [ -default default ] [ -bind bind_set_id | -bind bind_value_list ]
-
@return 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.
@param dbn The database name to use. If empty_string, uses the default database.
@param cache_key Cache the result using given value as the key. Default is to not cache.
@param cache_pool Override the default db_cache_pool
@param subst Perform Tcl substitution in xql-files. Possible values: all, none, vars, commands
+ @param default Return value in case the SQL query returns no value
+ @param bind Either an ns_set id, or bind value list
} {
# Query Dispatcher (OpenACS - ben)
set full_name [db_qd_get_fullname $statement_name]
- ad_arg_parser { default bind } $args
-
set code {
db_with_handle -dbn $dbn db {
set selection [db_exec -subst $subst 0or1row $db $full_name $sql]