Overview   Library    Tag    Help 
 FRAMES   NO FRAMES 

dbforms
Tag confTableData

external data to be nested into radio, checkbox or select - tag!(useful only in conjunction with radio, checkbox or select - tag) this tag provides similar functionality to "TableData", but as it allows to use the table data given in the conf file and use a filter clause like in dbform tag

Example: 
					
						this tag provides data to radio, checkbox or
						select - tags. It may be used for cross
						references to other tables.
					
					
						Example:
						
					
					
						<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:tableData
						
						name="aQuery"
						
						foreignTable="Cities"
						
						visibleFields="city_name, city_state"
						
						storeField="city_id"/>
						
						</db:select>

Tag Information
Tag Classorg.dbforms.taglib.ConfTableDataTag
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" 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 if you need the second field of the table you can use the notation format="%2$s"!
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
foreignTabletruetruejava.lang.Stringthe name of the table where
disableCachefalsetruejava.lang.StringEach query is executed independently
orderByfalsetruejava.lang.StringSpecify an orderby clause for the query
storeFieldtruetruejava.lang.String Describes the field in wich the data should be stored
filterfalsetruejava.lang.String Describes a filter for the data. Format is like filter tag in dbform
sqlFilterfalsetruejava.lang.String a filter in sql syntax which will be added to the where clause

Variables
No Variables Defined.

 Overview   Library    Tag    Help 
 FRAMES   NO FRAMES 
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.