Database Query
+
+Templating System : API
+Reference
Summary
Utilize the results of a database query as a template data
source.
@@ -46,19 +49,21 @@
Note(s)
-- Valid values for structure are onevalue, onerow,
-multirow, onelist, nestedlist and multilist.
+
- Valid values for structure are onevalue,
+onerow, multirow, onelist, nestedlist and multilist.
-
sql may be any valid SQL statement whose result set
has the appropriate dimensions for the desired
structure.
- The db parameter is optional. If no parameter is
supplied, a handle will be requested to perform the query and then
-released immediately.
- The startrow and maxrows parameters are valid
-only for multirow queries. They may be specified to limit the rows
-from the query result that are included in the data source.
- The eval parameter takes a block of Tcl code to
+released immediately.
- The startrow and maxrows parameters are
+valid only for multirow queries. They may be specified to limit the
+rows from the query result that are included in the data
+source.
- The eval parameter takes a block of Tcl code to
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.
+set column values.- The bind option is valid only when using
+Oracle.
templating\@arsdigita.com