Index: openacs-4/packages/acs-core-docs/www/db-api.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/db-api.html,v diff -u -r1.40 -r1.41 --- openacs-4/packages/acs-core-docs/www/db-api.html 5 Jul 2004 14:24:59 -0000 1.40 +++ openacs-4/packages/acs-core-docs/www/db-api.html 16 Feb 2005 00:21:02 -0000 1.41 @@ -1,4 +1,4 @@ -The OpenACS Database Access API
Alex logo
Prev Chapter�11.�Development Reference Next

The OpenACS Database Access API

+The OpenACS Database Access API

Alex logo
Prev Chapter�11.�Development Reference Next

The OpenACS Database Access API

By Pete Su and Jon Salz. Modified by Roberto Mello.

Overview

One of OpenACS's great strengths is that code written for it is @@ -359,7 +359,25 @@ } { set user_url [acs_community_member_url -user_id $user_id] } -

+

+ You can also iterate over a multirow after it has been + created - check the documentation for + template::multirow

+ For example, + 

+db_multirow assets assets {
+  select asset_id,
+    from ...
+}
+
+..
+
+set asset_id_l [list]
+multirow foreach assets {
+  lappend asset_id_l $asset_id
+}
+

Technically it's equivalent to using a code block on + the end of your db_multirow.

db_null