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 -N -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">

-Database Access API

-

By Jon Salz. Revised and expanded by Roberto Mello (rmello -at fslc dot usu dot edu), July 2002.

-OpenACS docs are written by the named authors, and may be edited by -OpenACS documentation staff.
<authorblurb>

By Jon Salz. Revised and +expanded by Roberto Mello (rmello at fslc dot usu dot edu), July +2002.

</authorblurb>

@@ -585,13 +583,13 @@ code_block [ if_no_rows if_no_rows_block ]

Performs the SQL query sql, saving results in variables of the form -var_name:1, -var_name:2, etc, setting +var_name:1, +var_name:2, etc, setting -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 +var_name:columns to a list +of column names.

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 { col_1col_2 ... } switch. This is useful for things like constructing a URL for the object retrieved by the query.

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.11.2.3 2017/04/21 15:07:53 -gustafn Exp $)
+

($‌Id: db-api.xml,v 1.12 2017/08/07 23:47:55 +gustafn Exp $)