dbforms
Tag queryData


external data to be nested into radio, checkbox or select - tag!(useful only in conjunction with radio, checkbox or select - tag)

Example:
					
						this tag provides data (provided by query
						result) to radio, checkbox or select - tags.
					
					
						this tag provides similar functionlaity like
						"TableData", but as it allows
						toformulate
						free querys
						including all SQL statements your RDBMS
						supports, you have muchmore flexibility using
						this tag than using TableData (which is easier
						to use, on the other hand)
					
					
						<!We want to display a drop down list with
						data from the Cities table,
						
						use the city_reference value for the default
						list selection -->
						
						<db:select
						fieldName="city_reference">
						
						<db:queryData name="aQuery"
						
						query="Select city_id, city_name,
						city_state from Cities"/>
						
						</db:select>
						
						
					
				


Tag Information
Tag Classorg.dbforms.taglib.QueryDataTag
TagExtraInfo ClassNone
Body ContentJSP
Display NameNone

Attributes
NameRequiredRequest-timeTypeDescription
nametruetruejava.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
dbConnectionNamefalsetruejava.lang.String indicate which dbconnection object to user.
formatfalsetruejava.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
formatClassfalsetruejava.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
querytruetruejava.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
disableCachefalsetruejava.lang.StringEach query is executed independently

Variables
No Variables Defined.


Output Generated by Tag Library Documentation Generator. Java, JSP, and JavaServer Pages are trademarks or registered trademarks of Sun Microsystems, Inc. in the US and other countries. Copyright 2002-4 Sun Microsystems, Inc. 4150 Network Circle Santa Clara, CA 95054, U.S.A. All Rights Reserved.