Index: openacs-4/packages/acs-templating/www/doc/api/database.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/api/database.adp,v diff -u -r1.2 -r1.2.2.1 --- openacs-4/packages/acs-templating/www/doc/api/database.adp 27 Oct 2014 16:40:18 -0000 1.2 +++ openacs-4/packages/acs-templating/www/doc/api/database.adp 25 Aug 2015 18:02:13 -0000 1.2.2.1 @@ -2,16 +2,21 @@ {/doc/acs-templating {Templating}} {Templating System API: Database Query} Templating System API: Database Query - - -

Database Query

Summary

Utilize the results of a database query as a template data -source.

Method

+Database Query
+Summary
+Utilize the results of a database query as a template data
+source.
+Method
+ query name structure sql -db dbhandle 
                              -startrow n 
                              -maxrows n
                              -bind (set|list)
                              -eval { code }
-
Perform a query and store the results in a local variable.
Examples
+
+Perform a query and store the results in a local variable.
+Examples
+ set db [ns_db gethandle]
 
 # this will set a scalar named current_time
@@ -38,7 +43,9 @@
 template::query persons nestedlist "
   select state, city, first_name, last_name from users" \
   -db $db -groupby { state city }
-
Note(s)

+

Note(s)

Valid values for structure are onevalue, onerow, multirow, onelist, nestedlist and multilist.
@@ -52,5 +59,6 @@ perform on each row of a multirow query as it is fetched from the database. The code may refer to the row array to get and set column values.
The bind option is valid only when using Oracle.

templating\@arsdigita.com - + +

+templating\@arsdigita.com