query is a defined SQL SELECT such as a
SQL join that can be referenced as if it were a table. A query is
defined within a
query element. The
query element has the same structure
(attributes and subelements)
table element but with
some additional subelements and additional attributes on the
query element itself to
define the query by supplying portions of the SQL SELECT
There is an additional repeating subelement
search which occurs after the other
subelements as listed in the preceding section on the
table element. The
search subelement allows the query to
contain dynamic parameters. The
search subelement has no element
content but does have three attributes. The
db:search> tag in a JSP page
provides the link between a user-entered value and the query. It also
provides the comparison operator used between the column or expression and
the user-entered data value. The attributes are listed below.
nameattribute using the SQL AS operator. Optional.
See Chapter 13, Query Support for more information.