Index: openacs-4/packages/acs-core-docs/www/db-api-detailed.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/db-api-detailed.adp,v diff -u -r1.2 -r1.3 --- openacs-4/packages/acs-core-docs/www/db-api-detailed.adp 7 Aug 2017 23:47:49 -0000 1.2 +++ openacs-4/packages/acs-core-docs/www/db-api-detailed.adp 8 Nov 2017 09:42:10 -0000 1.3 @@ -9,11 +9,9 @@ rightLink="i18n-requirements" rightLabel="Next">
<authorblurb>By Jon Salz. Revised and +expanded by Roberto Mello (rmello at fslc dot usu dot edu), July +2002.
</authorblurb>Tcl procedures: /packages/acs-kernel/10-database-procs.tcl
Tcl initialization: /packages/acs-kernel/database-init.tcl
Performs the SQL query sql
,
saving results in variables of the form
-var_name:1
,
-var_name:2
, etc, setting
+var_name
:1,
+
, etc, setting
var_name
:2
-var_name:rowcount
to the total
-number of rows, and setting
-var_name:columns
to a list of
-column names.
Each row also has a column, rownum, automatically added and set
+var_name
:rowcount to the
+total number of rows, and setting
+
to a list
+of column names.var_name
:columns
Each row also has a column, rownum, automatically added and set to the row number, starting with 1. Note that this will override any column in the SQL statement named 'rownum', also if you're using the Oracle rownum pseudo-column.
If the -local
is passed, the
@@ -604,7 +602,7 @@
all the columns from the SQL query will be set as local variables
in that code. Any changes made to these local variables will be
copied back into the multirow.
You may also add additional, computed columns to the multirow,
-using the -extend { col_1col_2 ... }
switch. This is
+using the -extend {
switch. This is
useful for things like constructing a URL for the object retrieved
by the query.col_1
col_2
... }
If you're constructing your multirow through multiple queries with the same set of columns, but with different rows, you @@ -703,8 +701,8 @@ script and should never be referenced directly by user code. Returns the current rdbms type and version.
-($Id: db-api.xml,v 1.12 2017/08/07 23:47:55 +gustafn Exp $)