Attributes |
Name | Required | Request-time | Type | Description |
name | true | true | java.lang.String |
an arbitrary id declared by the user - this id
is useful, if the same data should be used more
than once at one jsp page. using this unique
name the system is able to chache the data
|
dbConnectionName | false | true | java.lang.String |
indicate which dbconnection object to user.
|
format | false | true | java.lang.String |
specify a format to be used in concatenating
several display fields.
When more then one (1) field is shown, the
fields are, by default, separated by a
comma.
The format attribute was strengthened to
make it similar to the Unix sprintf utility.
There is now a need to be type specific
with the attribute.
For example,
format="%s is about %.2f" would be
where your float (ie%.2f) would be truncated
to two decimals.
ONLY THE DISPLAY VALUE WILL BE TRUNCATED
For more info, please see the Unix man page
or
http://developer.java.sun.com/developer/technicalArticles/Programming/sprintf/
or the javadocs
Example:
<db:tableData name="aQuery"
foreignTable="Cities"
visibleFields="city_id, city_name,
city_state"
format = "%i, %s / %s"
storeField="city_id"/>
Can be used when city_id is an integer,
city_name and city_state are strings in your
database.
Result -> 014, Naples / Florida
|
formatClass | false | true | java.lang.String |
class to use for special formatting.
This class must be derivide from
org.dbforms.util.PrintfFormat.
This class will be loaded through reflection api
and will be used to format the output.
Default is org.dbforms.util.PrintfFormat
|
query | true | true | java.lang.String |
the query used to retrieve the data
query building convention:
first column is the "key" column
for the radio/check/selectelements, all
other colums are just "data"
columns visible to the user
example: SELECT DISTINCT customer.id,
customer.name, customer.adress,
debitors.debit FROM customer INNER JOIN id
ON (SELECT id FROM debitors WHERE
debit>100000) ORDER BY debit DESC
- "id" will be threaten as
key-value in select box, "name and
address will be shown in select box
|
disableCache | false | true | java.lang.String | Each query is executed independently |