DbForms Custom Tag Library
Tag library version: 2.6-SNAPSHOT
Tag nameDescription
dbform a database application form (root element of a JSP view)
header this tag renders a Header-tag. It should be nested within a dbform-tag
body this tag renders a Body-tag. It should to be nested within a dbform-tag.
footer the footer grouping tag. it is supposed to be nested within a dbform-tag
label this tag renders a dabase-datadriven LABEL, which is a passive element (it can't be changed bythe user) - it is predestinated for use with read-only data (i.e. primary keys you don't want the user to change, etc)
dateLabel label - a tag for date data PRESENTATION, NOT data EDITING (=> can never be used as input field)
dataLabel label - a tag for data PRESENTATION, NOT data EDITING (=> can never be used as input field)
textField this tag renders a dabase-datadriven TEXTFIELD, which is an active element - the usercan change data
dateField this tag renders a dabase-datadriven DATE-FIELD, which is an active element - the usercan change data. it is very similar to TextField, especially since they now both support global setting for each type and language.
textArearenders a HTML TEXTAREA element
textAreaForBlobsrenders a HTML TEXTAREA element
tableData external data to be nested into radio, checkbox or select - tag!(useful only in conjunction with radio, checkbox or select - 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
queryData external data to be nested into radio, checkbox or select - tag!(useful only in conjunction with radio, checkbox or select - tag)
staticData external data to be nested into radio, checkbox or select - tag!(useful only in conjunction with radio, checkbox or select - tag)
staticDataItem data to be nested into staticData element! (see description of staticData for further details)
getConnection Allows other tags (or scriptlets) to obtain a database connection object using the same settings found in dbForms-config.xml
setDataSource Allows other tags (or scriptlets) to obtain a DataSource using the same settings found in dbForms-config.xml
file this tag renders an UPLOAD-button for uploading files into BLOBs or DISKBLOBs
radio renders a HTML RADIO element or a whole group of them
checkbox renders a HTML CHECKBOX element or a whole group of them
select This tag renders a html SELECT element including embedded OPTION elements.
linkURLgenerates a link to a DbForms View
position element to be embedded inside a linkURL-element
insertButtonthis tag renders an INSERT-button
deleteButtonthis tag renders a DELETE-button
updateButtonthis tag renders an UPDATE-button
navPrevButton this tag renders a navigation button for scrolling to previous row(s) of the current table
navNextButton this tag renders a navigation button for scrolling to next row(s) of the current table
navFirstButton this tag renders a navigation button for scrolling to the first row(s) of the current table
navLastButton this tag renders a navigation button for scrolling to the last row(s) of the current table
navNewButton this tag renders a navigation button for creating a new row of data
navCopyButton this tag renders a navigation button for creating a copy of a row of data that you can then modify and insert
navReloadButton this tag renders a navigation button for reloading and moving to the first row of the current table
gotoButtonbutton for jumping to other jsp
baserenders a HTML-BASE tag
errors Custom tag that renders error messages if an appropriate request attributehas been created.
xmlErrors Custom tag that renders error messages if an appropriate request attributehas been created. Used in conjuction with xml error manager
hasError This tag renders it's body if an error has occured
hasMoreRecords Verifies if the number of records in the result set is larger then the number specified
hasNoRecords Verifies if the number of records in the result set equal 0
hasRecords Verifies if the number of records in the result set is not equal 0
associatedRadio This tag enables the end-user to define a row by selecting the radio-buttonrendered by this tag
blobURL This tag generates an URL pointing to a servlet downloading the DISKBLOB referenced by fieldName
blobContent
sort this tag rendes a select box for switching the order-state of a field (ascending, descending, none) (this tag is full functional but still subject of change)
stylegeneric style tag
templateParamparam name
templateBasedir writes out base dir of the current template
message this tag renders a read-only text label. The data displayed is retrieved via a resource bundle and is locale-specific.
javascriptArray This tag was added to allow the generation of a javascript array from EmbeddedData.
isWebEvent Allows a developer to detect which type of event is being processed by the DbForms controller. The following events are currently available within dbForms: navFirst,navPrev, navNext, navLast, navNew, noop, goto, insert, update, delete
pos Renders a position to use with keyToDestPos. This is the same string wich would be used as value in the DbassociatedRadioTag.
search Renders all the needed fields for searching. Hides the searchfieldName stuff from the JSP developer. Rewrites the input field with the old value.
searchCombo Renders all the needed fields for searching with a comboBox. Hides the searchfieldName stuff from the JSP developer. Rewrites the input field with the old value. Can be used together with tableData, queryData or staticData.
searchCheckBox Renders a CheckBox for searching. The field value wich is searched for is the value of the value attribute. Renders all the needed fields for searching. Hides the searchfieldName stuff from the JSP developer.
filter Create a set of sql filter conditions, letting user select which one will be applied.
filterCondition Holds an sql condition that has to be nested inside a DbFilterTag.
filterValue Map a placeholder (?) in sql code to an input tag. Used as nested tag inside filterCondition.
redirectURLforce a redirect to a DbForms View
setCustomFormatter Register a Custom Formatter for later use
textFormat this tag formats a value with dbforms format settings
pieData This datatag generates a cewolf DatasetProducer with PieDataSet included. Data is taken from the dbforms resultsetvector.
categoryData This datatag generates a cewolf DatasetProducer with CategoryDataSet included. Data is taken from the dbforms resultsetvector.
highLowData This datatag generates a cewolf DatasetProducer with a OHCDDataSet included. This can be used to produce a HighLow plot. Data is taken from the dbforms resultsetvector.
timeSeriesData This datatag generates a cewolf DatasetProducer for a timeSeriesDataSet included. Data is taken from the dbforms resultsetvector. Inside this tag must be at least one timeSeriesField tag defined which will helds the information for the values
timeSeriesField This tags defines the fields for a cewolf timeSeries data tag
property Name/value-pair to paramterize a surrounding tag whose handler must implement the IPropertyList interface.
presetFormValues Register a custom handler which is called before the filter values are retrieved, just after calling the table before select handler. This handler can be used to preset form values
dbform - a database application form (root element of a JSP view)

this is the root element of a data manipulation form

Attribute NameDescription
id

expose id, enables interaction with JavaScript (not supported by all browsers!)

[RTExpValue]
dbConnectionName

indicate which dbconnection object to user.

[RTExpValue]
name

the name of this dbform tag

needed to reference the tag if tableName attribute is calculated at runtime

tableName

the name of the table/view referenced by the dbform

not required if form is empty!

[RTExpValue]
action

Override the servlet to which the dbform should be submitted

Default is the org.dbforms.Controller servlet

Useful when dbForms is used in read-only mode.

Example:

< db:dbform table="TABLE1" followUp="this.jsp" action = "/demo/servlet/com.abc.myServlet">

[RTExpValue]
readOnly

Rendering of read-only html widgets

WARNING: This is not terribly secure as it becomes editable if javascript is disabled in the browser. A More secure option is not placing an update button on your form.

[RTExpValue]
tableList

Allows a user to specify a list of tables to select from
Used in conjuction with the whereClause attribute
The value specified in the tableList attribute is used to specify the 'from'
part of the Select query. Hence the name: table list.

The conditions used to define the table associations are specified in the whereClause attribute.( along with other conditions and orderBy)
Multiple table access is valid only for data retrieval.
Insert, Update, and Delete are not supported.

Example:

In dbForms-config.xml:

<table name="AnyName">

<field name="Table1.id" fieldType="VARCHAR2" isKey="true"/>

<field name="Table2.id" fieldType="VARCHAR2" isKey="true"/>

<field name="Table1.fieldName" fieldType="VARCHAR2"/>

<field name="Table2.OtherField" fieldType="NUMBER"/>

</table>

In jsp:

<db:form tableName="AnyName" maxRows="*" followUp="next.jsp" tableList="Table1,Table2" whereClause="Where Table1.id = Table2.id"> <db:header/>

<db:body> <db:textField fieldName="Table1.fieldName"/> <db:textField fieldName="Table2.otherField"/>

</db:body> <db:footer/> </db:form>

Resulting Query:

SELECT Table1.id, Table2.id,Table1.fieldName,Table2.otherField FROM Table1,Table2 WHERE Table1.id = Table2.id

[RTExpValue]
searchFilterRequired

If set to true, the actual resultSet is obtained only if search filters have been specified, otherwise an empty resultset is returned. Perfect for situations where, without search filters, the resultset would be much too large. This feature validates the following:

  • searchTag contains a value
  • the filter attribute (dbforms tag) contains a value
  • a filter tag is specified

[RTExpValue]
maxRows

Determines how many times the body tag and its sub-elements get executed (evaluated and rendered):

  • maxRows = n => body gets executed n times (with n elementOF N)
  • maxRows = "*" => body gets executed for every row in the table (=> "endless" form)

not required if form is empty!

[RTExpValue]
whereClause

Replaces the filter attribute in situations where the whereClause is more complex. Allows a developer to specify a free form conditional clause (where Clause + order + etc).

Also, the whereClause can not be used with orderBy or filter attributes. They will be ignored. Order by should be used within the whereClause instead.

If you use the whereClause searching and sorting will not work! See the new <filter> tag to search/sort with complex where clauses.

Example:

<% StringBuffer whereClause = new StringBuffer();
whereClause.append("WHERE (FIELD1>'25' AND FIELD1<'50' ) OR FIELD2 NOT NULL ORDERBY FIELD7"); %>

<db:dbform table="TABLE1" followUp="this.jsp" whereClause = "<%whereClause.toString()%>">

[RTExpValue]
formValidatorName

this attribute contains the name of the form which is used for validation (defined in the validation.xml file).

[RTExpValue]
captionResource

this attribute is to be used in conjunction with the internationalization support in dbForms v1.1+. It allows the developer to specify if the 'caption' attribute values, found in embedded button tags, should be looked up in the associated resource bundles. By default, this attribute is set to 'false'.

[RTExpValue]
javascriptValidation

this attribute is used to specify if client-side validation (javascript) should be executed. By default, this attribute is set to 'false'. Default javascripts are defined in the validator-rules.xml file.

[RTExpValue]
javascriptValidationSrcFile

this attribute allows a developer to specify a javascript file (.js) to be used for client-side validation. Default javascripts are defined in the validator-rules.xml file.

[RTExpValue]
javascriptFieldsArray

this attribute is used to specify if dbForms should generate a javascript method which can be used by (javascript) developers for referencing dbform-generated field names . By default, this attribute is set to 'false'.

Generated code example:

<SCRIPT language="javascript">

<!--

var dbformFields = new Array();
dbformFields["phone"] = "f_0_0@root_8";
dbformFields["bugstate"] = "f_0_0@root_9";
dbformFields["reporter"] = "f_0_0@root_7";
dbformFields["priority"] = "f_0_0@root_2";
dbformFields["description"] = "f_0_0@root_4";
dbformFields["category"] = "f_0_0@root_1";

function getDbFormFieldName(name){
return dbformFields[name];
}
-->
</SCRIPT>

[RTExpValue]
redisplayFieldsOnError

In a jsp which contains many input fields, it may be desirable, in the event of an error, to redisplay input data.(instead of refreshing the fields from the DB) DbForms implements this functionality by default with INSERT fields only. If you choose to set this attribute to "true" then DbForms will redisplay entered values even with UPDATES.

[RTExpValue]
followUp

site to be invoked after action

Note that buttons can override followUp (and followUpOnError) settings defined in the dbform tag

[RTExpValue]
followUpOnError

site to be invoked after action, if error occured on page

Note that buttons can override followUp (and followUpOnError) settings defined in the dbform tag

[RTExpValue]
autoUpdate

if "true", at every action (navigation, insert, update, etc.) all input fields of ALL currently rendered rowsets are parsed and updated. many rows may be affected. This can be very useful if people need to change lots of data, even multiple datarows, at once if "false", updates are only performed if an explicite "update"- action is launched (normally by hitting the updateAction-button). Only the current row is affected. if "OnUpdateOnly", updates are only performed if an explicite "update" - action is launched (normally by hitting the updateAction-button), all input fields of ALL currently rendered rowsets are parsed and updated. Many rows may be affected. This can be very useful if people need to change lots of data, even multiple datarows, at once.

[RTExpValue]
overrideFieldCheck

If set to true the field values will not be checked if they are changed. The database update will be done always This could be usefull if you want to call your interceptor always to check fields which are not part of the table. In your interceptor you can use return DbEventInterceptor.IGNORE_OPERATION if you do not want the database update

[RTExpValue]
parentField

used in sub-form: field(s) in the main form that is/are linked to this form

Should either be a key or set to sortable="true" in dbforms-config.xml

[RTExpValue]
childField

used in sub-form: field(s) in this form that is/are linked to the parent form

Should either be a key or set to sortable="true" in dbforms-config.xml

[RTExpValue]
target

pendant to the html-target attribute in html-form tag: the target frame to jump to

[RTExpValue]
multipart

multipart must be set to "true" if the form contains file-upload tags or if the form may be invoked by a form containing file-upload tags, orif it containts fields of BLOB or DISKBLOB.

default is "false" (multipart-support off)

[RTExpValue]
orderBy

a SQL orderBy-CLAUSE (without the keyword "ORDER BY")

example:

  • "id, name desc"
  • "id"
  • "id asc"
  • "firstname asc, lastname desc"
important:
  • if you use a non-primary key, you MUST specify sortable="true" within your dbforms-config.xml file for the key you want to sort by
  • if you do not specify it here, you may define it globally in your dbforms-config.xml file. If you do not specify any information, DbForms automatically takes the key-fields for sorting.
  • remember field names are CASE SENSITIVE in DbForms framework (at least in current version)

[RTExpValue]
filter

definition of a FILTER. Format: Fieldname/Fielvalue pairs, seperated by , or ; symbol.

Examples:

  • filter="id=2"
  • filter="id=2;name=Hugo Berger"
  • filter="deptno=101,salery>=30000,name~Peter"

    the ~ symbol is an aquivalant to the SQL keyword "LIKE" used in SELECT statements!

since version 0.9, you can use <, > <= and >= operators, too!

<db:dbform tableName="employee" maxRows="*" followUp="/employees.jsp" autoUpdate="false" filter ="deptno=101,salary>=30000,name~Peter%" ...
< /db:dbform >

Operator: Meaning: Example:
= Equals aField=value
							<> Not Equal aField<>value
						
< Smaller then aField<100
> Greater then aField>0
							<= Smaller then or equal aField<=100
						
							>= Greater then or equal aField>=0
						
~ Like aField~%P%
Since version 1.1.3pr1:
ISNULL is null aField ISNULL
							NOTISNULL is not null aField NOTISNULL
						

By default, all filter definitions are ANDed together. If you wish to use OR, you may prefix your filter definition with the '|' symbol. (even better! - use the whereClause attribute )

Example:

aFieldVal=3, |anotherField>3

would produce the following:

... where aFieldVal=3 OR anotherField>3

filter will be overwritten by searching!

[RTExpValue]
sqlFilter

a filter in sql syntax which will be added to the where clause

[RTExpValue]
gotoPrefix

allows to define a prefix applied to request parameters in order to provide
a convenient and easyway of implementing navigation. Using this attribute may
substitute the use of the more complicated and not very convenient GotoButton-Tag!

example:

  • if you define gotoPrefix="fv_"
  • then you can call your jsp that way: customers.jsp?fv_id=4

=> DbForms fetches the value of fv_ id which is "4" and then navigates to the row where id is 4.

this attribute was added in release 0.9

[RTExpValue]
gotoHt

allows to define a hashtable containing fieldName / fieldValue combinations which represent the valueof a key
(which can consist of more than one field, of course!)

example:

you could define a hashtable "myGotoHash" and apply it to the attribute

								<%Hashtable myGotoHash =
								null;if(request.getParameter("goto")!=null)
								{ myGotoHash = new
								Hashtable();myGotoHash.put("id",request.getParameter("goto"));
								}%>

								<db:form table="customer"
								followUp="customer.jsp" gotoHt="<%=
								myGotoHash %>" > ... some code
								...</db:form>
							

now, when a user calls aview.jsp?goto=234, then DbForms will navigate thetable to the row where id==234!

there are many other ways you can use this facility. the only important thing is that
the key value(s) in the hashtables refer to valid field names of the table.

BE SURE TO SPECIFY ALL YOUR KEYS OR NAVIGATION WILL BE UNPREDICTABLE [ if you do not know what all the values should be, use a wildcard like: myGotoHash.put("how_used","*"); and navigation will be to the first instance

this attribute was added in release 0.9

[RTExpValue]
localWebEvent

this attribute allows a JSP view developer to trigger WebEvents(NavigationsEvents)on the JSP.
No controller interaction is needed. This attribute aims to make linkage between dialogs easier.

currently, the available "local web event"-commands are:

  • navFirst
  • navPrev
  • navNext
  • navLast
  • navNew

if a developer wants to show the last row of a table, then she/he could apply the value
"navNext" to this attribute. Note that this attribute is evaluated in runtime,
this gives additional flexibility

this attribute was added in release 0.9

[RTExpValue]
onSubmit

JavaScript event handler executed before the form is submited. If the event handler returns FALSE,
the form will not be submitted. When the result is TRUE, the form will be submitted

[RTExpValue]
autocomplete

if the autocomplete value is specified then the attribute is inserted in the form tag.
if the value is "off" and if the browser has autocompletion ability, it can be disabled
with this tag.
Any value will be accepted for autocomplete. e.g. autocomplete="any",
the generated HTML code is:
<form name="dbforms" ... autocomplete="any" ... >

[RTExpValue]
header - this tag renders a Header-tag. It should be nested within a dbform-tag

this tag renders a Header-tag. Itshould to be nested within a dbform-tag.because this tag
is nested within a dbform-tag it is invoked every time the parent dbform-tag getsevaluated,
but it gets only rendered at the FIRST evalation-loop.

This tag has no attributes.

body - this tag renders a Body-tag. It should to be nested within a dbform-tag.

the body grouping tag

this tag renders a Body-tag. It should to be nested within a dbform-tag.because this tag
is nested within a dbform-tag it is invoked every time the parent dbform-tag getsevaluated,
AND it gets rendered in every evalation-loop (if there exists data to be rendered)

Attribute NameDescription
allowNew

by default this is "true" - if so, the body is rendered at least 1 time,
even if there are no data rows in the table. this enables the user to insert a new data row.
- to disable this feature, allowNew has to be set to "false"

[RTExpValue]
footer - the footer grouping tag. it is supposed to be nested within a dbform-tag

this tag renders a Footer-tag. it should be nested within a dbform-tag.because this tag is nested within a dbform-tag it is invoked every time the parent dbform-tag getsevaluated, but it gets only rendered at the end of the last evaluation-loop.

This tag has no attributes.

label - this tag renders a dabase-datadriven LABEL, which is a passive element (it can't be changed bythe user) - it is predestinated for use with read-only data (i.e. primary keys you don't want the user to change, etc)

label - can never be used as input field

Attribute NameDescription
fieldName

name of the field this tag references to

[Required][RTExpValue]
maxlength

Set a limit to the number of characters visible

[RTExpValue]
nullFieldValue

If the value (retrieved from the database) is null, allow the user to replace the text to display by a custom value. May be used in conjunction with dbForm's I18N support.

[RTExpValue]
pattern

When dealing with numeric or date/time values, you could use the Java API to format the output of the text field expressions yourself using the format attribute. But there is a more convenient way to do it: by using the pattern attribute. The value you should supply to this attribute is the same that you would supply if it were for you to format the value using either the java.text.DecimalFormat class or java.text.SimpleDateFormat class, depending on the type of value to format. In fact, what the engine does is to instantiate the java.text.DecimalFormat class if the text field expression returns subclasses of the java.lang.Number class or to instantiate the java.text.SimpleDataFormat if the text field expression return java.util.Date or java.sql.Timestamp objects. For more detail about the syntax of this pattern attribute, check the Java API documentation for those two classes: java.text.DecimalFormat and java.text.SimpleDateFormat.

[RTExpValue]
customFormatter

The name of a formatting instance registered previously by using the setCustomFormatter tag

[RTExpValue]
styleClass

CSS stylesheet class to be applied. This is done adding a SPAN element that contains the text.

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
dateLabel - label - a tag for date data PRESENTATION, NOT data EDITING (=> can never be used as input field)
Attribute NameDescription
fieldName  [Required][RTExpValue]
pattern

When dealing with numeric or date/time values, you could use the Java API to format the output of the text field expressions yourself using the format attribute. But there is a more convenient way to do it: by using the pattern attribute. The value you should supply to this attribute is the same that you would supply if it were for you to format the value using either the java.text.DecimalFormat class or java.text.SimpleDateFormat class, depending on the type of value to format. In fact, what the engine does is to instantiate the java.text.DecimalFormat class if the text field expression returns subclasses of the java.lang.Number class or to instantiate the java.text.SimpleDataFormat if the text field expression return java.util.Date or java.sql.Timestamp objects. For more detail about the syntax of this pattern attribute, check the Java API documentation for those two classes: java.text.DecimalFormat and java.text.SimpleDateFormat.

[RTExpValue]
customFormatter

The name of a formatting instance registered previously by using the setCustomFormatter tag

[RTExpValue]
nullFieldValue

If the value (retrieved from the database) is null, allow the user to replace the text to display by a custom value. May be used in conjunction with dbForm's I18N support.

[RTExpValue]
styleClass

CSS stylesheet class to be applied. This is done adding a SPAN element that contains the text.

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
dataLabel - label - a tag for data PRESENTATION, NOT data EDITING (=> can never be used as input field)

this tag renders a dabase-datadriven LABEL, which is a passive element (it can't be changed bythe user) - it is predestinated for use with read-only data (i.e. primary keys you don't wantthe user to change, etc)

so far it is equivalent to DbLabelTag. But this tag may have a body containing any kind ofEmbeddedData - tag! this feature was put into a seperate class for performance reasons (we do not want the overheadof pushing and poping the jsp writer to and off the stack)

The dataLabel tag contains an EmbeddedData tag (TableData, QueryData, or StaticData) The fieldName (defined in dataLabel) is used as a lookup for an element in the embeddedData collection.

Example:

<!We have an ID, we want to display the Description -look it up in the Priorities table -->
<db:dataLabel fieldName="ID_Priority">
<db:queryData name="aQuery" query="SELECT ID_Priority, Description from Priorities"/>
</db:dataLabel>

Attribute NameDescription
fieldName

name of the field this tag references to

[Required][RTExpValue]
strict

if strict is true, value is set to empty string if it's not found in the embedded data. otherwise it's set to the formatted field value. default is false, so that it act's like before.

[RTExpValue]
maxlength

Allows a developer to limit the amount of characters displayed on screen. If the label to display exceeds the limit, trim and display '...'

Example:

<db:dataLabel fieldName="ABC" maxlength="10"> </db:dataLabel>

[RTExpValue]
nullFieldValue

If the value (retrieved from the database) is null, allow the user to replace the text to display by a custom value. May be used in conjunction with dbForm's I18N support.

[RTExpValue]
styleClass

CSS stylesheet class to be applied. This is done adding a SPAN element that contains the text.

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
textField - this tag renders a dabase-datadriven TEXTFIELD, which is an active element - the usercan change data

i/o text field

Attribute NameDescription
id

expose id, enables interaction with JavaScript

Identification which can be used to 'pinpoint' dbForms fields for use in JavaScript methods. Nota bene: Not supported by all browser!

Example:

<db:textField fieldName="FIELD1" maxlength="15" id="InputField1"/>

[RTExpValue]
fieldName

name of the field this tag references to

[Required][RTExpValue]
password

visually encrypted input field

[RTExpValue]
defaultValue

default field name to use if the specified field is empty.

[RTExpValue]
pattern

When dealing with numeric or date/time values, you could use the Java API to format the output of the text field expressions yourself using the format attribute. But there is a more convenient way to do it: by using the pattern attribute. The value you should supply to this attribute is the same that you would supply if it were for you to format the value using either the java.text.DecimalFormat class or java.text.SimpleDateFormat class, depending on the type of value to format. In fact, what the engine does is to instantiate the java.text.DecimalFormat class if the text field expression returns subclasses of the java.lang.Number class or to instantiate the java.text.SimpleDataFormat if the text field expression return java.util.Date or java.sql.Timestamp objects. For more detail about the syntax of this pattern attribute, check the Java API documentation for those two classes: java.text.DecimalFormat and java.text.SimpleDateFormat.

[RTExpValue]
customFormatter

The name of a formatting instance registered previously by using the setCustomFormatter tag

[RTExpValue]
hidden

Determines if the text field should be hidden or displayed.

[RTExpValue]
overrideValue

Defines the text field's default value. When this attribute is set,the value retrieved from the database is ignored.

[RTExpValue]
nullFieldValue

If the value (retrieved from the database) is null, allow the user to replace the text to display by a custom value. May be used in conjunction with dbForm's I18N support.

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
maxlength

Maximum length of the string to be entered

[RTExpValue]
readOnly

Rendering of read-only html widgets

WARNING: This is not terribly secure as it becomes editable if javascript is disabled in the browser. A More secure option is not placing an update button on your form.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
size

Size of the input field

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
readOnlyStyleClass

CSS stylesheet class to be applied to this HTML element (read-only mode).

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
dateField - this tag renders a dabase-datadriven DATE-FIELD, which is an active element - the usercan change data. it is very similar to TextField, especially since they now both support global setting for each type and language.

Example:

							<dateField pattern="date"
						

To set the pattern which data is displayed in use a resource bundle (See the UsersGuide chapter on Internationalization).

Example of ApplicationResources.properties:

						dbforms.pattern.date=yyyy-MM-dd
						dbforms.pattern.timestamp=yyyy-MM-dd HH:mm
					

Attribute NameDescription
id

expose id, enables interaction with JavaScript

[RTExpValue]
fieldName

name of the field this tag references to

[Required][RTExpValue]
pattern

When dealing with numeric or date/time values, you could use the Java API to format the output of the text field expressions yourself using the format attribute. But there is a more convenient way to do it: by using the pattern attribute. The value you should supply to this attribute is the same that you would supply if it were for you to format the value using either the java.text.DecimalFormat class or java.text.SimpleDateFormat class, depending on the type of value to format. In fact, what the engine does is to instantiate the java.text.DecimalFormat class if the text field expression returns subclasses of the java.lang.Number class or to instantiate the java.text.SimpleDataFormat if the text field expression return java.util.Date or java.sql.Timestamp objects. For more detail about the syntax of this pattern attribute, check the Java API documentation for those two classes: java.text.DecimalFormat and java.text.SimpleDateFormat.

[RTExpValue]
customFormatter

The name of a formatting instance registered previously by using the setCustomFormatter tag

[RTExpValue]
hidden

Determines if the text field should be hidden or displayed.

[RTExpValue]
nullFieldValue

if the value (retrieved from the database) is null, allow the user to replace the text to display by a custom value. May be used inconjunction with dbForm's I18N support.

[RTExpValue]
overrideValue

Defines the text field's default value. When this attribute is set,the value retrieved from the database is ignored.

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
maxlength

Maximum length of the string to be entered

[RTExpValue]
readOnly

Rendering of read-only html widgets

WARNING: This is not terribly secure as it becomes editable if javascript is disabled in the browser. A More secure option is not placing an update button on your form.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
size

Size of the input field

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
readOnlyStyleClass

CSS stylesheet class to be applied to this HTML element (read-only mode).

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
useJsCalendar

Place small calendar icon after input field. Clicking that icon will popup a JavaScript calendar that can be used to set a new value for the field. Some preparations have to be done, the calendar must be copied into the web applications and must be included in current page. See dbforms manual for details.

[RTExpValue]
jsCalendarDateFormat

Subpatterns inside date formats have sometimes different meanings in Java and inside JavaScript calendar. For some date formats it may be neccessary to explicitely set a date format to the calendar that corresponds to the used date format inside dbforms application. See dbforms manual for details.

[RTExpValue]
classicCalendar

Determinate whether the classic javascript calendar should be used.[may be deprecated soon]

[RTExpValue]
textArea - renders a HTML TEXTAREA element

i/o textarea

Attribute NameDescription
id

expose id, enables interaction with JavaScript

[RTExpValue]
fieldName

name of the field this tag references to

[Required][RTExpValue]
defaultValue

default field name to use if the specified field is empty.

[RTExpValue]
nullFieldValue

If the value (retrieved from the database) is null, allow the user to replace the text to display by a custom value. May be used in conjunction with dbForm's I18N support.

[RTExpValue]
pattern

When dealing with numeric or date/time values, you could use the Java API to format the output of the text field expressions yourself using the format attribute. But there is a more convenient way to do it: by using the pattern attribute. The value you should supply to this attribute is the same that you would supply if it were for you to format the value using either the java.text.DecimalFormat class or java.text.SimpleDateFormat class, depending on the type of value to format. In fact, what the engine does is to instantiate the java.text.DecimalFormat class if the text field expression returns subclasses of the java.lang.Number class or to instantiate the java.text.SimpleDataFormat if the text field expression return java.util.Date or java.sql.Timestamp objects. For more detail about the syntax of this pattern attribute, check the Java API documentation for those two classes: java.text.DecimalFormat and java.text.SimpleDateFormat.

[RTExpValue]
customFormatter

The name of a formatting instance registered previously by using the setCustomFormatter tag

[RTExpValue]
rows

how many rows does the textArea have

[RTExpValue]
cols

how many columns does the textArea have

[RTExpValue]
wrap

may be:

  • "virtual" - text get wrapped optically
  • "phyiscal" - text get wrapped optically and physically (line breaks)

[RTExpValue]
overrideValue

Defines the textarea's default value. When this attribute is set,the value retrieved from the database is ignored.

[RTExpValue]
renderBody

if the content inside the body of this tag should be rendered or if the value of the associated field should be shown instead

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
readOnly

Rendering of read-only html widgets

WARNING: This is not terribly secure as it becomes editable if javascript is disabled in the browser. A More secure option is not placing an update button on your form.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
readOnlyStyleClass

CSS stylesheet class to be applied to this HTML element (read-only mode).

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
textAreaForBlobs - renders a HTML TEXTAREA element

i/o textarea for character diskblobs. use it if you want users to edit files using textareas

Attribute NameDescription
id

expose id, enables interaction with JavaScript

[RTExpValue]
fieldName

name of the field this tag references to
This tag is used to display disk-blob-generated text fields which may, or may not require scrolling.

Example:

<db:textAreaForBlobs fieldName = "filePath"
renderBody = "true" suffix = "jsp"
rows = "15" cols = "60" wrap = "virtual">
<db:blobContent fieldName = "filePath"/>
</db:textAreaForBlobs>

Note:
renderBody attribute must be set to true.
fieldPath is of type DISKBLOB.

[Required][RTExpValue]
pattern

When dealing with numeric or date/time values, you could use the Java API to format the output of the text field expressions yourself using the format attribute. But there is a more convenient way to do it: by using the pattern attribute. The value you should supply to this attribute is the same that you would supply if it were for you to format the value using either the java.text.DecimalFormat class or java.text.SimpleDateFormat class, depending on the type of value to format. In fact, what the engine does is to instantiate the java.text.DecimalFormat class if the text field expression returns subclasses of the java.lang.Number class or to instantiate the java.text.SimpleDataFormat if the text field expression return java.util.Date or java.sql.Timestamp objects. For more detail about the syntax of this pattern attribute, check the Java API documentation for those two classes: java.text.DecimalFormat and java.text.SimpleDateFormat.

[RTExpValue]
customFormatter

The name of a formatting instance registered previously by using the setCustomFormatter tag

[RTExpValue]
rows

how many rows does the textArea have

[RTExpValue]
cols

how many columns does the textArea have

[RTExpValue]
wrap

may be:

  • "virtual" - text get wrapped optically
  • "phyiscal" - text get wrapped optically and physically (line breaks)

[RTExpValue]
overrideValue

Defines the textarea's default value. When this attribute is set,the value retrieved from the database is ignored.

[RTExpValue]
renderBody

if the content inside the body of this tag should be rendered or if the value of the associated field should be shown instead

[RTExpValue]
suffix

suffix, e.g. jsp, xml, etc.

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
readOnly

Rendering of read-only html widgets

WARNING: This is not terribly secure as it becomes editable if javascript is disabled in the browser. A More secure option is not placing an update button on your form.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
readOnlyStyleClass

CSS stylesheet class to be applied to this HTML element (read-only mode).

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

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

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>

Attribute NameDescription
name

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

[Required][RTExpValue]
dbConnectionName

indicate which dbconnection object to user.

[RTExpValue]
format

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

[RTExpValue]
formatClass

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

[RTExpValue]
foreignTable

the name of the table where

[Required][RTExpValue]
visibleFields  [Required][RTExpValue]
disableCache

Each query is executed independently

[RTExpValue]
orderBy

Specify an orderby clause for the query

[RTExpValue]
storeField

Describes the field in wich the data should be stored

[Required][RTExpValue]
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

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>

Attribute NameDescription
name

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

[Required][RTExpValue]
dbConnectionName

indicate which dbconnection object to user.

[RTExpValue]
format

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"!

[RTExpValue]
formatClass

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

[RTExpValue]
foreignTable

the name of the table where

[Required][RTExpValue]
disableCache

Each query is executed independently

[RTExpValue]
orderBy

Specify an orderby clause for the query

[RTExpValue]
storeField

Describes the field in wich the data should be stored

[Required][RTExpValue]
filter

Describes a filter for the data. Format is like filter tag in dbform

[RTExpValue]
sqlFilter

a filter in sql syntax which will be added to the where clause

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

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>

Attribute NameDescription
name

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

[Required][RTExpValue]
dbConnectionName

indicate which dbconnection object to user.

[RTExpValue]
format

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

[RTExpValue]
formatClass

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

[RTExpValue]
query

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

[Required][RTExpValue]
disableCache

Each query is executed independently

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

this tag provides data to radio, checkbox or select - tags. This data is provided byembedded "StaticDataItem"-elements

this tag provides similar functionlaity like "TableData" or "QueryData" but as the namessuggest, the values of TableData and QueryData come from a database, the data in in StaticDataItem comes from the jsp page (from "StaticDataItem"-elements)

Example:

<!We want to display a drop down list with days of the week,
use the day_reference value for the default list selection-->
<db:select fieldName="day_reference">
<db:staticData name="myQuery">
<db:staticDataItem key="0" value="Sunday"/>
<db:staticDataItem key="1" value="Monday"/>
<db:staticDataItem key="2" value="Tuesday"/>
<db:staticDataItem key="3" value="Wednesday"/>
<db:staticDataItem key="4" value="Thursday"/>
<db:staticDataItem key="5" value="Friday"/>
<db:staticDataItem key="6" value="Saturday"/>
</db:staticData>
</db:select>

Attribute NameDescription
name

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

[Required][RTExpValue]
staticDataItem - data to be nested into staticData element! (see description of staticData for further details)
Attribute NameDescription
key  [Required][RTExpValue]
value  [Required][RTExpValue]
getConnection - Allows other tags (or scriptlets) to obtain a database connection object using the same settings found in dbForms-config.xml
Attribute NameDescription
id

Attribute in page that will be used to reference the connection object Allows other tags (and/or java scriptlets) to obtain a connection via the same settings as defined in dbForms
Example:
<db:getConnection id="myConnection">
<!-- Open connection -->
<sql: statement id="stmt" conn="myConnection">
<sql:query>Select * from Table</sql:query>
<sql:resultSet id="rs">
Value: <sql:getColumn position="1"/>
</sql:resultSet>
</sql:statement>
</db:getConnection>
<!-- close connection -->

[Required][RTExpValue]
dbConnectionName

indicate which dbconnection object to user.

[RTExpValue]
setDataSource - Allows other tags (or scriptlets) to obtain a DataSource using the same settings found in dbForms-config.xml
Attribute NameDescription
dataSource

Attribute in page that will be used to reference the connection object Allows other tags (and/or java scriptlets) to obtain a connection via the same settings as defined in dbForms

Example: (using Jakarta dbTags)
<db:setDataSource dataSource="myDataSource" />
<sql:query var="qry" dataSource="${myDataSource}">Select * from Table</sql:query>
<c:forEach var="row" items="${qry.rows}" >
Value: <c:out value="{row.field}" />
</c:forEach>

[Required][RTExpValue]
dbConnectionName

indicate which dbconnection object to user.

[RTExpValue]
file - this tag renders an UPLOAD-button for uploading files into BLOBs or DISKBLOBs

version 0.7 provides a first implementation of file upload support. It is far from being completed. Improvementsin functionality and performance can be expected.

Attribute NameDescription
id

Identification which can be used to 'pinpoint' dbForms fields for use in JavaScript methods. Note: Not supported by all browser!

Example:

<db:file fieldName="page" id="file2"/>

[RTExpValue]
fieldName

name of the field this tag references to

[Required][RTExpValue]
accept

MIME(s)-types of the fields to be uploaded. you may use wildcards as well

example: accept="text/*" for text, htm, html,etc.

keep in mind that not all browsers support MIME type filtering.

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
maxlength

Maximum length of the string to be entered

[RTExpValue]
readOnly

Rendering of read-only html widgets

WARNING: This is not terribly secure as it becomes editable if javascript is disabled in the browser. A More secure option is not placing an update button on your form.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
size

Size of the input field

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
readOnlyStyleClass

CSS stylesheet class to be applied to this HTML element (read-only mode).

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
radio - renders a HTML RADIO element or a whole group of them

radio tag, may be a radio group as well and it may contain nested DbData-Tags(like tableData, queryData, staticData, ...)

Example:

<!We want to display a group of radio button, use the value of fieldName 'timeframe' for the default list selection. In INSERT mode, use the
first entry -->
<db:radio fieldName="timeframe"
growDirection="vertical"
defaultValue="0" >
<db:staticData name="myQuery">
<db:staticDataItem key="0" value="9:00 12:00"/>
<db:staticDataItem key="1" value="12:01 15:00"/>
<db:staticDataItem key="2" value="15:01 18:00"/>
<db:staticDataItem key="3" value="18:01 21:00"/>
</db:staticData>
</db:radio>

Attribute NameDescription
id

Identification which can be used to 'pinpoint' dbForms fields for use in JavaScript methods. Note: Not supported by all browser!

Example:

<db:radio fieldName="FIELD3" id="radioGroup"> </db:radio>

[RTExpValue]
fieldName

name of the field this tag references to

[Required][RTExpValue]
defaultValue

default field name to use if the specified field is empty.

[RTExpValue]
growDirection

for radio groups only: in which direction should the group grow: valid values are "horizontal" and "vertical"

[RTExpValue]
growSize

Allows a developer to limit the number of elements per row by generating [TABLE] [TR] [TD] html tags.

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
readOnly

Rendering of read-only html widgets

WARNING: This is not terribly secure as it becomes editable if javascript is disabled in the browser. A More secure option is not placing an update button on your form.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
readOnlyStyleClass

CSS stylesheet class to be applied to this HTML element (read-only mode).

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
checkbox - renders a HTML CHECKBOX element or a whole group of them

radio tag, may be a radio group as well and it may contain nested DbData-Tags(like tableData, queryData, staticData, ...)

Example:

<!We want to display a checkbox which, when checked, is set to "yes" -->
<db:checkbox fieldName="yesNo" value="yes" checked="true"/>

Attribute NameDescription
id

expose id, enables interaction with JavaScript

[RTExpValue]
fieldName

name of the field this tag references to

[Required][RTExpValue]
value

value that should be used if checkbox is checked

dbforms will compare this value with the value in the database

[RTExpValue]
novalue

value that should be used if check box is not checked

[RTExpValue]
checked

determinates if this checkbox should be checked by default when form is in insert mode

only needed if parentForm is in "insert-mode", otherwise the DbForms-Framework determinates whether a checkbox should be selected or not.

[RTExpValue]
force

If true value of checked attribute is always used.

[RTExpValue]
growDirection

for checkbox groups only: in which direction should the group grow: valid values are "horizontal" and "vertical"

[RTExpValue]
growSize

Allows a developer to limit the number of elements per row by generating [TABLE] [TR] [TD] html tags.

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
readOnly

Rendering of read-only html widgets

WARNING: This is not terribly secure as it becomes editable if javascript is disabled in the browser. A More secure option is not placing an update button on your form.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
readOnlyStyleClass

CSS stylesheet class to be applied to this HTML element (read-only mode).

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
select - This tag renders a html SELECT element including embedded OPTION elements.

select tag, may contain nested "DbData"-Tags (OR "dboption" tags, which are not implemented yet)
examples for DbData-Tags are tableData, queryData, staticData

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.
Added a blank entry as default selection -->
<db:select fieldName="city_reference" customEntry="001,,true">
<db:queryData
name="aQuery"
query="Select city_id, city_name, city_state from Cities"/>
</db:select>

info

Attribute NameDescription
id

Identification which can be used to 'pinpoint' dbForms fields for use in JavaScript methods. Note: Not supported by all browser!

Example:

<db:select fieldName="FIELD3" id="mySelect"></db:select>

[RTExpValue]
fieldName

name of the field this tag references to

[Required][RTExpValue]
size

how many rows should the select box have

[RTExpValue]
selectedIndex  [RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
readOnly

Rendering of read-only html widgets

WARNING: This is not terribly secure as it becomes editable if javascript is disabled in the browser. A More secure option is not placing an update button on your form.

[RTExpValue]
pattern

When dealing with numeric or date/time values, you could use the Java API to format the output of the text field expressions yourself using the format attribute. But there is a more convenient way to do it: by using the pattern attribute. Useful in select if you have a 4 digit lookup value and want to avoid it being reformatted with the default locale as #,###. Use pattern="#" to avoid this.

[RTExpValue]
customEntry

Allows the possibility of adding an entry in the select list which is independent of data retrieved via tableData, queryData or

staticData. Arguments to this tag are as follows:

Key,Description,boolean (default selection?)

[RTExpValue]
ifEmptyItem

Item to be used if there is no embedded data Arguments to this tag are as follows: Key,Description

[RTExpValue]
ifEmptyDontDraw

Do not draw the Select box if there is no data

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects an item

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
readOnlyStyleClass

CSS stylesheet class to be applied to this HTML element (read-only mode).

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
linkURL - generates a link to a DbForms View

generates a link to a DbForms View. Setting the positionattribute will force DbForms to navigate to this position within the destination-table

the 3 examles below produce all the same result

<linkURL href="customer.jsp" tableName="customer" position="103~2"/>

<linkURL href="customer.jsp" tableName="customer" position="<%= currentKey %>"/>

<linkURL href="customer.jsp" tableName="customer">
<position field="id" value="103"/>
<position field="cust_lang" value="2"/>
</linkURL>

Attribute NameDescription
href

the url of the JSP file representing the view

[Required][RTExpValue]
tableName

the url of the table the view represents

[Required][RTExpValue]
position

optional: the position to navigate to within table "tableName"

for backwards compatibility is the same as destPos!

[RTExpValue]
parentField

used if parentTable is different to tableName: field(s) in the main form that is/are linked to this form

[RTExpValue]
childField

used if parentTable is different to tableName: field(s) in this form that is/are linked to the parent form

[RTExpValue]
destPos

a value indicating the row to navigate to. Position strings are used as request parameters allowing the framework to keep track of the position the user comes from or goes to. This string is structured as follows:

fieldId : fieldValueLength : fieldValue

It is important to note that if multiple keys exist in the definition of the table, your position string must includes values for each key. (separated by dashes (-))

Example:

<! Jump to another JSP, specify position using multiple keys-->
<db:gotoButton caption="View Sample Details" destination="/viewSample.jsp"
destTable="Sample" destPos="1:6:widget-3:2:23"/>

[RTExpValue]
keyToDestPos

a key indicating the row to navigate to.

Example:

<! Jump to another JSP, specify position through a key -->
<db:gotoButton caption="View Sample Details" destination="/viewSample.jsp"
destTable="Sample" keyToDestPos="k_1_1@root"/>

[RTExpValue]
keyToKeyToDestPos

a key to the key indicating the row to navigate to. For each record in the result-set, the associatedRadio tag generates a key reference which can be used to retrieve a position string.

Example:

<!for each record, generate a key to the position string -->
<db:body><db:associatedRadio name="test"/></db:body>

<db:footer>
<! Jump to another JSP, specify position (get second record using appropriate key!)-->
<db:gotoButton caption="View Sample Details" destination="/viewSample.jsp"
destTable="Sample" keyToKeyDestPos="test"/>

Check "customerlist.jsp" in example!

[RTExpValue]
singleRow

if set to true, only one row of data will be fetched. default is false, so that all rows of data will be fetched and the requested record will be set as actual record.

[RTExpValue]
position - element to be embedded inside a linkURL-element

example:

<linkURL href="customer.jsp" tableName="customer">
<position fieldName="id" value="103"/>
<position fieldName="cust_lang" value="2"/>
</linkURL>

Attention: field to reference must be a key field in the target table!

Attribute NameDescription
fieldName

name of the key-field

[Required][RTExpValue]
value

value of the key field

[Required][RTExpValue]
insertButton - this tag renders an INSERT-button

this tag renders an insert-button

the button is hidden if embedding form is not in insert mode

Attribute NameDescription
id

expose id, enables interaction with JavaScript

[RTExpValue]
flavor

styling of the button

choices:
  • standard a standard form button. if you use it you should specify "caption"
  • image an image-button. if you use it you should specify "src" and "alt"
  • modern a fancy button according to HTML4; dont use if no all of your users have got 5th-generation browsers! You may embed any code into this tag. (see docu or www.w3.org)

[RTExpValue]
showAlways

From v_1_1_3pr1:

If false (which is the default setting), the input button will be rendered
only in insert mode -- such as through a NavNewEvent.

For previously generated list_and_single.jsp or self coded pages,
the attribute showAlways="true" should be added to the insertButtonTag,
unless it will be used in insert mode.

<db:insertButton caption="Insert new ..." styleClass="clsButtonStyle" showAlways="true"/>

[RTExpValue]
caption

caption of the button (use it if the chosen flavor is "standard")

[RTExpValue]
src

source of the image (use it if the chosen flavor is "image")

[RTExpValue]
alt

alternative to image (use it if the chosen flavor is "image")

[RTExpValue]
border

set html border attribute

[RTExpValue]
followUp

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUp-attribute of the parent form(s)!

[RTExpValue]
followUpOnError

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUpOnError-attribute of the parent form(s)!

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
deleteButton - this tag renders a DELETE-button

delete button

the button is hidden if embedding form is in insert mode

Attribute NameDescription
id

expose id, enables interaction with JavaScript

[RTExpValue]
flavor

styling of the button

choices:
  • standard a standard form button. if you use it you should specify "caption"
  • image an image-button. if you use it you should specify "src" and "alt"
  • modern a fancy button according to HTML4; dont use if no all of your users have got 5th-generation browsers! You may embed any code into this tag. (see docu or www.w3.org)

[RTExpValue]
caption

caption of the button. (use it if the chosen flavor is "standard") If the value of the 'captionResource' attribute in the parent dbform is 'true', this tag retrieves it's content via a resource bundle. Refer to gotoButton for example.

[RTExpValue]
src

source of the image (use it if the coosen flavor is "image")

[RTExpValue]
alt

alternative to image (use it if the coosen flavor is "image")

[RTExpValue]
border

set html border attribute

[RTExpValue]
confirmMessage

This attribute will generate a javascript message asking if the user really wants to delete this entry. If the 'captionResource' attribute of the (db)Form is set to true, the message can be resolve from a ResourceBundle (ref: I18N)

[RTExpValue]
followUp

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUp-attribute of the parent form(s)!

[RTExpValue]
followUpOnError

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUpOnError-attribute of the parent form(s)!

[RTExpValue]
associatedRadio

determinates the unique name of a data-row-marking "radio"-element (this MUST extist on thesame JSP - page as this button!

it should be used if this button should be rendered only once and not for every rowthat could/should be deleted

see "associatedRadio"-tag for further information!

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
updateButton - this tag renders an UPDATE-button

update button

the button is hidden if embedding form is in insert mode

Attribute NameDescription
id

expose id, enables interaction with JavaScript

[RTExpValue]
flavor

styling of the button

choices:
  • standard a standard form button. if you use it you should specify "caption"
  • image an image-button. if you use it you should specify "src" and "alt"
  • modern a fancy button according to HTML4; dont use if no all of your users have got 5th-generation browsers! You may embed any code into this tag. (see docu or www.w3.org)

[RTExpValue]
showAlways

If false (which is the default setting), the update button will be rendered
only if resultset contains data

[RTExpValue]
caption

caption of the button. (use it if the chosen flavor is "standard") If the value of the 'captionResource' attribute in the parent dbform is 'true', this tag retrieves it's content via a resource bundle. Refer to gotoButton for example.

[RTExpValue]
src

source of the image (use it if the coosen flavor is "image")

[RTExpValue]
alt

alternative to image (use it if the coosen flavor is "image")

[RTExpValue]
border

set html border attribute

[RTExpValue]
followUp

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUp-attribute of the parent form(s)!

[RTExpValue]
followUpOnError

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUpOnError-attribute of the parent form(s)!

[RTExpValue]
associatedRadio

determinates the unique name of a data-row-marking "radio"-element (this MUST extist on thesame JSP - page as this button!

it should be used if this button should be rendered only once and not for every rowthat could/should be updated

see "associatedRadio"-tag for further information!

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
navPrevButton - this tag renders a navigation button for scrolling to previous row(s) of the current table

navigation button to scroll back

Attribute NameDescription
id

expose id, enables interaction with JavaScript

[RTExpValue]
flavor

styling of the button

choices:
  • standard a standard form button. if you use it you should specify "caption"
  • image an image-button. if you use it you should specify "src" and "alt"
  • modern a fancy button according to HTML4; dont use if no all of your users have got 5th-generation browsers! You may embed any code into this tag. (see docu or www.w3.org)

[RTExpValue]
caption

caption of the button. (use it if the chosen flavor is "standard") If the value of the 'captionResource' attribute in the parent dbform is 'true', this tag retrieves it's content via a resource bundle. Refer to gotoButton for example.

[RTExpValue]
src

source of the image (use it if the coosen flavor is "image")

[RTExpValue]
alt

alternative to image (use it if the coosen flavor is "image")

[RTExpValue]
border

set html border attribute

[RTExpValue]
stepWidth

how many rows of data should be scrolled

[RTExpValue]
followUp

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUp-attribute of the parent form(s)!

[RTExpValue]
followUpOnError

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUpOnError-attribute of the parent form(s)!

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
disabledBehaviour

Describes the behaviour of this button if it is on the first page. possible values:

  • nohtml: no HTML output
  • altimage: only an image with no functionality is displayed. The src for that image can be specified in the attribute disabledImageSrc which can have an alt attribute specified in disabledImageAlt and width and height specified by disabledImageWidth and disabledImageHeight.
  • disabled (default): The image specified in scr is used but disabled.

example:
<db:navPrevButton src="images/ico_prev.gif" flavor="image" disabledBehaviour="altimage" disabledImageSrc="images/transparent.gif" disabledImageAlt="my alt text" disabledImageWidth="50" disabledImageHeight="1" onMouseOver="javascript: self.status='previous'; return true;" onMouseOut="javascript: self.status=''; return true;"/>
If on first page, HTML result is:
<img src="images/transparent.gif" alt="my alt text" width="50" height="1" />

[RTExpValue]
disabledImageSrc

see disabledBehaviour

[RTExpValue]
disabledImageAlt

see disabledBehaviour

[RTExpValue]
disabledImageWidth

see disabledBehaviour

[RTExpValue]
disabledImageHeight

see disabledBehaviour

[RTExpValue]
navNextButton - this tag renders a navigation button for scrolling to next row(s) of the current table

navigation button to scroll to next dataset(s)

Attribute NameDescription
id

expose id, enables interaction with JavaScript

[RTExpValue]
flavor

styling of the button

choices:
  • standard a standard form button. if you use it you should specify "caption"
  • image an image-button. if you use it you should specify "src" and "alt"
  • modern a fancy button according to HTML4; dont use if no all of your users have got 5th-generation browsers! You may embed any code into this tag. (see docu or www.w3.org)

[RTExpValue]
caption

caption of the button. (use it if the chosen flavor is "standard") If the value of the 'captionResource' attribute in the parent dbform is 'true', this tag retrieves it's content via a resource bundle. Refer to gotoButton for example.

[RTExpValue]
src

source of the image (use it if the coosen flavor is "image")

[RTExpValue]
alt

alternative to image (use it if the coosen flavor is "image")

[RTExpValue]
border

set html border attribute

[RTExpValue]
stepWidth

how many rows of data should be scrolled

[RTExpValue]
followUp

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUp-attribute of the parent form(s)!

[RTExpValue]
followUpOnError

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUpOnError-attribute of the parent form(s)!

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
disabledBehaviour

Describes the behaviour of this button if it is on the last page. possible values:

  • nohtml: no HTML output
  • altimage: only an image with no functionality is displayed. The src for that image can be specified in the attribute disabledImageSrc which can have an alt attribute specified in disabledImageAlt and width and height specified by disabledImageWidth and disabledImageHeight.
  • disabled (default): The image specified in scr is used but disabled.

example:
<db:navNextButton src="images/ico_next.gif" flavor="image" disabledBehaviour="altimage" disabledImageSrc="images/transparent.gif" disabledImageAlt="my alt text" disabledImageWidth="50" disabledImageHeight="1" onMouseOver="javascript: self.status='next'; return true;" onMouseOut="javascript: self.status=''; return true;"/>
If on last page, HTML result is:
<img src="images/transparent.gif" alt="my alt text" width="50" height="1" />

[RTExpValue]
disabledImageSrc

see disabledBehaviour

[RTExpValue]
disabledImageAlt

see disabledBehaviour

[RTExpValue]
disabledImageWidth

see disabledBehaviour

[RTExpValue]
disabledImageHeight

see disabledBehaviour

[RTExpValue]
navFirstButton - this tag renders a navigation button for scrolling to the first row(s) of the current table

navigation button to scroll to first dataset

Attribute NameDescription
id

expose id, enables interaction with JavaScript

[RTExpValue]
flavor

styling of the button

choices:
  • standard a standard form button. if you use it you should specify "caption"
  • image an image-button. if you use it you should specify "src" and "alt"
  • modern a fancy button according to HTML4; dont use if no all of your users have got 5th-generation browsers! You may embed any code into this tag. (see docu or www.w3.org)

[RTExpValue]
caption

caption of the button. (use it if the chosen flavor is "standard") If the value of the 'captionResource' attribute in the parent dbform is 'true', this tag retrieves it's content via a resource bundle. Refer to gotoButton for example.

[RTExpValue]
src

source of the image (use it if the coosen flavor is "image")

[RTExpValue]
alt

alternative to image (use it if the coosen flavor is "image")

[RTExpValue]
border

set html border attribute

[RTExpValue]
followUp

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUp-attribute of the parent form(s)!

[RTExpValue]
followUpOnError

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUpOnError-attribute of the parent form(s)!

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
disabledBehaviour

Describes the behaviour of this button if it is on the first page. possible values:

  • nohtml: no HTML output
  • altimage: only an image with no functionality is displayed. The src for that image can be specified in the attribute disabledImageSrc which can have an alt attribute specified in disabledImageAlt and width and height specified by disabledImageWidth and disabledImageHeight.
  • disabled (default): The image specified in scr is used but disabled.

example:
<db:navFirstButton src="images/ico_first.gif" flavor="image" disabledBehaviour="altimage" disabledImageSrc="images/transparent.gif" disabledImageAlt="my alt text" disabledImageWidth="50" disabledImageHeight="1" onMouseOver="javascript: self.status='first'; return true;" onMouseOut="javascript: self.status=''; return true;"/>
If on first page, HTML result is:
<img src="images/transparent.gif" alt="my alt text" width="50" height="1" />

[RTExpValue]
disabledImageSrc

see disabledBehaviour

[RTExpValue]
disabledImageAlt

see disabledBehaviour

[RTExpValue]
disabledImageWidth

see disabledBehaviour

[RTExpValue]
disabledImageHeight

see disabledBehaviour

[RTExpValue]
navLastButton - this tag renders a navigation button for scrolling to the last row(s) of the current table

navigation button to scroll to last dataset

Attribute NameDescription
id

expose id, enables interaction with JavaScript

[RTExpValue]
flavor

styling of the button

choices:
  • standard a standard form button. if you use it you should specify "caption"
  • image an image-button. if you use it you should specify "src" and "alt"
  • modern a fancy button according to HTML4; dont use if no all of your users have got 5th-generation browsers! You may embed any code into this tag. (see docu or www.w3.org)

[RTExpValue]
caption

caption of the button. (use it if the chosen flavor is "standard") If the value of the 'captionResource' attribute in the parent dbform is 'true', this tag retrieves it's content via a resource bundle. Refer to gotoButton for example.

[RTExpValue]
src

source of the image (use it if the coosen flavor is "image")

[RTExpValue]
alt

alternative to image (use it if the coosen flavor is "image")

[RTExpValue]
border

set html border attribute

[RTExpValue]
followUp

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUp-attribute of the parent form(s)!

[RTExpValue]
followUpOnError

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUpOnError-attribute of the parent form(s)!

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
disabledBehaviour

Describes the behaviour of this button if it is on the last page. possible values:

  • nohtml: no HTML output
  • altimage: only an image with no functionality is displayed. The src for that image can be specified in the attribute disabledImageSrc which can have an alt attribute specified in disabledImageAlt and width and height specified by disabledImageWidth and disabledImageHeight.
  • disabled (default): The image specified in scr is used but disabled.

example:
<db:navLastButton src="images/ico_last.gif" flavor="image" disabledBehaviour="altimage" disabledImageSrc="images/transparent.gif" disabledImageAlt="my alt text" disabledImageWidth="50" disabledImageHeight="1" onMouseOver="javascript: self.status='last'; return true;" onMouseOut="javascript: self.status=''; return true;"/>
If on last page, HTML result is:
<img src="images/transparent.gif" alt="my alt text" width="50" height="1" />

[RTExpValue]
disabledImageSrc

see disabledBehaviour

[RTExpValue]
disabledImageAlt

see disabledBehaviour

[RTExpValue]
disabledImageWidth

see disabledBehaviour

[RTExpValue]
disabledImageHeight

see disabledBehaviour

[RTExpValue]
navNewButton - this tag renders a navigation button for creating a new row of data

navigation button to scroll to new, empty dataset

the "allowNew"-attribute of the parten "body"-tag MUEST NOT set to "false" in order to get this to work.

Attribute NameDescription
id

expose id, enables interaction with JavaScript

[RTExpValue]
destTable

specify a table for insertion other than the parent table.

[RTExpValue]
flavor

styling of the button

choices:
  • standard a standard form button. if you use it you should specify "caption"
  • image an image-button. if you use it you should specify "src" and "alt"
  • modern a fancy button according to HTML4; dont use if no all of your users have got 5th-generation browsers! You may embed any code into this tag. (see docu or www.w3.org)

[RTExpValue]
caption

caption of the button. (use it if the chosen flavor is "standard") If the value of the 'captionResource' attribute in the parent dbform is 'true', this tag retrieves it's content via a resource bundle. Refer to gotoButton for example.

[RTExpValue]
src

source of the image (use it if the coosen flavor is "image")

[RTExpValue]
alt

alternative to image (use it if the coosen flavor is "image")

[RTExpValue]
showAlwaysInFooter

A NavNewButton is different from other buttons, it will normally even been shown if it is placed within footer of a dbforms tag with empty result set. This makes sense if you want to show a set of rows and then below always the button to open a form to insert a new row. But if you have a form with body attribute allowNew set to "true", an insert form will automatically be shown in case no row is found. In that case the button might irritate users, you should then set attribute showAlwaysInFooter to "false". Then the button will not be shown if result set is empty.

[RTExpValue]
border

set html border attribute

[RTExpValue]
followUp

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUp-attribute of the parent form(s)!

[RTExpValue]
followUpOnError

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUpOnError-attribute of the parent form(s)!

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to this element.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
navCopyButton - this tag renders a navigation button for creating a copy of a row of data that you can then modify and insert

navigation button to scroll to a copy of an existent dataset

It works with elements such as textField and textArea (even when hidden) but not with dataLabel.

Attribute NameDescription
id

expose id, enables interaction with JavaScript

[RTExpValue]
showAlwaysInFooter

A NavNewCopy is different from other buttons, it will normally even been shown if it is placed within footer of a dbforms tag with empty result set. This makes sense if you want to show a set of rows and then below always the button to open a form to insert a new row. But if you have a form with body attribute allowNew set to "true", an insert form will automatically be shown in case no row is found. In that case the button might irritate users, you should then set attribute showAlwaysInFooter to "false". Then the button will not be shown if result set is empty.

[RTExpValue]
flavor

styling of the button

choices:
  • standard a standard form button. if you use it you should specify "caption"
  • image an image-button. if you use it you should specify "src" and "alt"
  • modern a fancy button according to HTML4; dont use if no all of your users have got 5th-generation browsers! You may embed any code into this tag. (see docu or www.w3.org)

[RTExpValue]
caption

caption of the button (use it if the chosen flavor is "standard")

[RTExpValue]
src

source of the image (use it if the coosen flavor is "image")

[RTExpValue]
alt

alternative to image (use it if the coosen flavor is "image")

[RTExpValue]
border

set html border attribute

[RTExpValue]
followUp

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUp-attribute of the parent form(s)!

[RTExpValue]
followUpOnError

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUpOnError-attribute of the parent form(s)!

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to this element.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
navReloadButton - this tag renders a navigation button for reloading and moving to the first row of the current table

navigation button for reloading and moving to the first dataset

Attribute NameDescription
id

expose id, enables interaction with JavaScript

[RTExpValue]
flavor

styling of the button

choices:
  • standard a standard form button. if you use it you should specify "caption"
  • image an image-button. if you use it you should specify "src" and "alt"
  • modern a fancy button according to HTML4; dont use if no all of your users have got 5th-generation browsers! You may embed any code into this tag. (see docu or www.w3.org)

[RTExpValue]
caption

caption of the button. (use it if the chosen flavor is "standard") If the value of the 'captionResource' attribute in the parent dbform is 'true', this tag retrieves it's content via a resource bundle. Refer to gotoButton for example.

[RTExpValue]
src

source of the image (use it if the coosen flavor is "image")

[RTExpValue]
alt

alternative to image (use it if the coosen flavor is "image")

[RTExpValue]
border

set html border attribute

[RTExpValue]
followUp

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUp-attribute of the parent form(s)!

[RTExpValue]
followUpOnError

site to be invoked after this button has been clicked and the associated actions are done

this attribute over-rules the followUpOnError-attribute of the parent form(s)!

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
gotoButton - button for jumping to other jsp

The gotoButton tag can be used to forward processing to another JSP. Setting the position (via various gotoButton attributes) will force DbForms to navigate to this position within the destination-table.

Example:

<!Caption text should be retrieved via a resource bundle -->
<db:dbform tableName="MyTABLE" captionResource="true">

<! Jump to another JSP, no positionning -->
<db:gotoButton caption="menu" destination="/menu.jsp"/>

Attribute NameDescription
id

expose id, enables interaction with JavaScript

[RTExpValue]
flavor

styling of the button

choices:
  • standard a standard form button. if you use it you should specify "caption"
  • image an image-button. if you use it you should specify "src" and "alt"
  • modern a fancy button according to HTML4; dont use if no all of your users have got 5th-generation browsers! You may embed any code into this tag. (see docu or www.w3.org)

[RTExpValue]
caption

Caption of the button. (use it if the chosen flavor is "standard") If the value of the 'captionResource' attribute in the parent dbform is 'true', this tag retrieves it's content via a resource bundle.

[RTExpValue]
src

source of the image (use it if the coosen flavor is "image")

[RTExpValue]
alt

alternative to image (use it if the coosen flavor is "image")

[RTExpValue]
border

set html border attribute

[RTExpValue]
destination

the URL of the jsp-view to be invoked

[Required][RTExpValue]
destTable

the table of the toplevel form to jump to [may be deprecated soon]

[RTExpValue]
destPos

a value indicating the row to navigate to. Position strings are used as request parameters allowing the framework to keep track of the position the user comes from or goes to. This string is structured as follows:

fieldId : fieldValueLength : fieldValue

It is important to note that if multiple keys exist in the definition of the table, your position string must includes values for each key. (separated by dashes (-))

Example:

<! Jump to another JSP, specify position using multiple keys-->
<db:gotoButton caption="View Sample Details" destination="/viewSample.jsp"
destTable="Sample" destPos="1:6:widget-3:2:23"/>

[RTExpValue]
keyToDestPos

a key indicating the row to navigate to.

Example:

<! Jump to another JSP, specify position through a key -->
<db:gotoButton caption="View Sample Details" destination="/viewSample.jsp"
destTable="Sample" keyToDestPos="k_1_1@root"/>

[RTExpValue]
keyToKeyToDestPos

a key to the key indicating the row to navigate to. For each record in the result-set, the associatedRadio tag generates a key reference which can be used to retrieve a position string.

Example:

<!for each record, generate a key to the position string -->
<db:body><db:associatedRadio name="test"/></db:body>

<db:footer>
<! Jump to another JSP, specify position (get second record using appropriate key!)-->
<db:gotoButton caption="View Sample Details" destination="/viewSample.jsp"
destTable="Sample" keyToKeyDestPos="test"/>

Check "customerlist.jsp" in example!

Example for single form (works with mutilple key columns):

<db:body>
<input type="hidden" name="currentRow" value="<db:pos>"/>
</db:body>
<db:footer>
<db:gotoButton
caption="View Sample Details" destination="/viewSample.jsp"
destTable="Sample" keyToDestPos="currentRow"/>

[RTExpValue]
singleRow

if set to true, only one row of data will be fetched. default is false, so that all rows of data will be fetched and the requested record will be set as actual record.

[RTExpValue]
parentField

used in sub-form: field(s) in the main form that is/are linked to this form

Should either be a key or set to sortable="true" in dbforms-config.xml

[RTExpValue]
childField

used in sub-form: field(s) in this form that is/are linked to the parent form

Should either be a key or set to sortable="true" in dbforms-config.xml

[RTExpValue]
accessKey

The keyboard character used to move focus immediately to thiselement.

[RTExpValue]
onBlur

JavaScript event handler executed when this element loses inputfocus.

[RTExpValue]
onChange

JavaScript event handler executed when this element loses inputfocus and its value has changed.

[RTExpValue]
onSelect

JavaScipt event hanlder executed when the user selects some text

[RTExpValue]
onClick

JavaScript event handler executed when this element receives amouse click.

[RTExpValue]
onDblClick

JavaScript event handler executed when this element receives amouse double click.

[RTExpValue]
onFocus

JavaScript event handler executed when this element receives inputfocus.

[RTExpValue]
onKeyDown

JavaScript event handler executed when this element has focus and akey is depressed.

[RTExpValue]
onKeyPress

JavaScript event handler executed when this element has focus and akey is depressed and released.

[RTExpValue]
onKeyUp

JavaScript event handler executed when this element has focus and akey is released.

[RTExpValue]
onMouseDown

JavaScript event handler executed when this element is under the mousepointer and a mouse button is depressed.

[RTExpValue]
onMouseMove

JavaScript event handler executed when this element is under themouse pointer and the pointer is moved.

[RTExpValue]
onMouseOut

JavaScript event handler executed when this element was under themouse pointer but the pointer was moved outside the element.

[RTExpValue]
onMouseOver

JavaScript event handler executed when this element was not underthe mouse pointer but the pointer is moved inside the element.

[RTExpValue]
onMouseUp

JavaScript event handler executed when this element is under themouse pointer and a mouse button is released.

[RTExpValue]
style

CSS styles to be applied to this HTML element.

[RTExpValue]
styleClass

CSS stylesheet class to be applied to this HTML element.

[RTExpValue]
title

this defines the "title" attribute for the HTML4 tag.

[RTExpValue]
tabIndex

The tab order (ascending positive integers) for this element.

[RTExpValue]
base - renders a HTML-BASE tag

Renders a HTML "base" element with a "href"-attribute pointing to the absolute location of the enclosing JSP page. The presenceof this tag allows the browser to resolve relative URL's to images,CSS stylesheets and other resources in a manner independent of the URLused to call the ControllerServlet. You should use this tag in all your JSP-views (seeexamples in distribution)

There are no attributes associated withthis tag.

This tag has no attributes.

errors - Custom tag that renders error messages if an appropriate request attributehas been created.

renders errors stored in request

Attribute NameDescription
caption

caption of the error-list

default = "Error:"

[RTExpValue]
name

the name that should be used for retrieving the error-data from the session

default = "errors"

[RTExpValue]
messagePrefix

Note: DbForms v1.0 no longer appends Exception messages together. Therefore the exception message you input is the only text contained in the message. Hence, no need for message Prefix anymore.

The user may define a messagePrefix attribute to specify a delimiter. If defined, only the exception message after the delimeter iswritten out. This can be used to produce a user interface with nice, clean output. If the error tag does not contain a value formessagePrefix, the tag works as normal (prints out the exception information)

[RTExpValue]
xmlErrors - Custom tag that renders error messages if an appropriate request attributehas been created. Used in conjuction with xml error manager

In order to manage error messages more efficiently, we introduced the new XmlError tag. Instead of hard coding your error messages within your interceptors, you can now define them in an xml file which is loaded at application start-up (in the exact same manner as the dbForms-config.xml file!) Furthermore, messages may be stored (and retrieved) for any given language. Here is how it works

Create an xml error file called dbForms-errors.xml with the following structure:

<dbforms-errors>
<error id="001" type="WARN">
<message language="Fracais">% - Champ est obligatoire% </message>
<message language="English">% - is mandatory %"</message>
</error> </dbforms-errors>

Replace the errors tag by the xmlErrors tag (in your jsp's).

In your interceptor, throw a ValidationException with the following message construct:
Language-MessageID:parameter,parameter,parameter
Where:
Language = used to locate which message to return, ends with a dash (-)
Message ID = error ID used for lookup, ends with a colon (:)
Parameter(s) = separated by commas, read in sequence, replaces placeholders (%) in message

Example:

String messageConstruct = "English-001:param1,param2";

throw new ValidationException(messageConstruct);

Note that you may also use this mechanism to intercept error messages which are generated by the database. Ie: Oracle throws the following message: ORA-0001: blah blah blah

<dbforms-errors>

<error id="0001" type="WARN">

<message language="ORA">Oracle message: % </message>

</error>

</dbforms-errors>

Attribute NameDescription
caption

caption of the error-list

default = "Error:"

[RTExpValue]
name

the name that should be used for retrieving the error-data from the session

default = "errors"

[RTExpValue]
hasError - This tag renders it's body if an error has occured

renders errors stored in request

Attribute NameDescription
name

the name that should be used for retrieving the error-data from the session

default = "errors"

[RTExpValue]
value

if set to TRUE body will be rendered if an error as occured.

if set to FALSE body will be rendered if no error has occured.

Default: TRUE

[RTExpValue]
hasMoreRecords - Verifies if the number of records in the result set is larger then the number specified
Attribute NameDescription
count

Number of records allowed

If the result Set contains >= the number of elements specified, display the appropriate message (XML error file). As with error messages, arguments may be passed to the message string via a comma delimited string.

Example:

<db:dbform table="TABLE"
maxRows="200"
followUp="next.jsp">
<db:header>
<!-Message: Resultset too big, displaying first 200 records -->
<db:hasMoreRecords count="200" message="English-001:200" />
</db:header>

</db:dbform>

[Required][RTExpValue]
message

Message to display (see xml error manager)

[RTExpValue]
hasNoRecords - Verifies if the number of records in the result set equal 0
Attribute NameDescription
message

Message to display (see xml error manager)

[RTExpValue]
hasRecords - Verifies if the number of records in the result set is not equal 0
Attribute NameDescription
message

Message to display (see xml error manager)

[RTExpValue]
associatedRadio - This tag enables the end-user to define a row by selecting the radio-buttonrendered by this tag

example: imagine a table "customer". The rows of this table should be listed. The user shouldbe able to delete a customer.

in that case the application developer has to alternatives:
  • to put a "deleteButton" into the body -> this button gets rendered for every row
    if the user clicks the button the associated data row gets deleted.the disadvantage of this method is that multiple buttons must be rendered, which takes awaylots of space and makes layouting more difficult
  • to put an "associatedRadio" into the body and the "deleteButton" on the footer (or header)
    the radio element gets rendered for every row, the deleteButton just once. if the user wantsto delete a row, he/she has to select the radioButton (to mark the row he/she wants to be deleted)and then to press the deleteButton.
  • the more buttons you have the better this method is!!

    nota bene: you have to tell the delete (or insert, update...) - button that there exists an associatedradio button that marks the row the action should be applied to, by defining the "associatedRadio"attribute of that respective button.

    Attribute NameDescription
    name

    a unique name for the radio box. this name is used by buttons like "deleteButton" or "updateButton"to lookup the valio of this radio!

    see "deleteButton" or "updateButton" for further information!

    [Required][RTExpValue]
    blobURL - This tag generates an URL pointing to a servlet downloading the DISKBLOB referenced by fieldName

    use cases:

    Attribute NameDescription
    fieldName

    name of the field this tag references to

    [Required][RTExpValue]
    defaultValue

    default field name to use if the specified field is empty.
    "Filesystem blob" example:

    <img src="<db:blobURL fieldName="THUMBNAIL" defaultValue="myImage.jpg"/>" border="0" width="xx" height="yy">

    Developers Note: this attribute (up to now) is not used for "database blob" data, works only for "Disk Blob" data. Update 03/2004: works now for BLOB data as well (if BLOB is not in classic mode and nameField is used)

    [RTExpValue]
    nameField

    this optional attribute may be used to tell the fileservlet in which table column (field) the name of the file is stored.

    This is (only) needed if you use the new (default) BLOB model which does not rely on FileHolder anymore to associate files and their names. Hence, the association between file and name must be captured by other means: During upload we use the BlobInterceptor, and during download we use this "nameField" argument.

    [RTExpValue]
    blobContent -
    Attribute NameDescription
    fieldName

    name of the field this tag references to

    [Required][RTExpValue]
    dbConnectionName

    indicate which dbconnection object to user.

    [RTExpValue]
    sort - this tag rendes a select box for switching the order-state of a field (ascending, descending, none) (this tag is full functional but still subject of change)
    Attribute NameDescription
    fieldName

    name of the field this tag references to

    [Required][RTExpValue]
    style - generic style tag
    Attribute NameDescription
    template

    name of the template to be included

    [Required][RTExpValue]
    part

    part of the template to be invoked

    [Required][RTExpValue]
    paramList

    parameter list used to specify rendering properties for the template

    [RTExpValue]
    templateParam - param name
    Attribute NameDescription
    name

    name of the template param to evaluate

    only used in template (_begin.jsp / _end.jsp) - definition files!

    [Required][RTExpValue]
    defaultValue

    default value to choose if no value specified in paramList - attribute in the db:style tag of the embedded jsp

    [RTExpValue]
    dir

    • if the parameter describes a ressource then dir should be set to the directory containing thatresource. this attribute notes RELATIVE to the directory of the current template.
      if your template is placed in /templates/mytemplate/ and you have images in a directory /templates/mytemplate/img/than just note dir as "img". if the images (or other resources) are in the /templates/mytemplateyou may set dir to "."
    • if you skip this attribute, then no directory will be written out. then only the actual valueof the param gets written out
      (for example if the parameter is "bgcolor=#343434" then you definitly wouldnot want any directories to be involved!!

    [RTExpValue]
    templateBasedir - writes out base dir of the current template

    only used in template (_begin.jsp / _end.jsp) - definition files!

    This tag has no attributes.

    message - this tag renders a read-only text label. The data displayed is retrieved via a resource bundle and is locale-specific.

    Example:

    <db:message key="testkey" param="param0, param1, param2" />

    testkey in resourcefile
    This is a testmessage with {0}, {1}, {2} params!

    Result
    This is a testmessage with param0, param1, param2 params!

    Attribute NameDescription
    key

    name of the key-field.

    [Required][RTExpValue]
    param

    parameterlist for the message. Format: param1, param2, param3 message must be of the form: 'this is a message with parameter: {0}, {1}, {3} each occurence of {0} will be replaced with param1 and so on. This is the same mechanism wich is used in xmlErrors!

    [RTExpValue]
    javascriptArray - This tag was added to allow the generation of a javascript array from EmbeddedData.
    Attribute NameDescription
    name

    name of the array.

    [Required][RTExpValue]
    isWebEvent - Allows a developer to detect which type of event is being processed by the DbForms controller. The following events are currently available within dbForms: navFirst,navPrev, navNext, navLast, navNew, noop, goto, insert, update, delete
    Attribute NameDescription
    event

    name of the event.

    [Required][RTExpValue]
    value

    Condition in which to evaluate body. Default is set to true.

    [RTExpValue]
    pos - Renders a position to use with keyToDestPos. This is the same string wich would be used as value in the DbassociatedRadioTag.
    This tag has no attributes.

    search - Renders all the needed fields for searching. Hides the searchfieldName stuff from the JSP developer. Rewrites the input field with the old value.

    example of result:

    Attribute NameDescription
    fieldName

    Name of the field in the table for which the searching should be done

    [Required][RTExpValue]
    hidden  [RTExpValue]
    searchAlgo

    The search algorithm. Default: sharp

    [RTExpValue]
    searchMode

    The search mode. Default: and

    [RTExpValue]
    default

    Default value for the field. This will be used at the first time the form is rendered

    [RTExpValue]
    id

    Renders HTML id field

    [RTExpValue]
    onBlur  [RTExpValue]
    onChange  [RTExpValue]
    onClick  [RTExpValue]
    onDblClick  [RTExpValue]
    onFocus  [RTExpValue]
    onKeyDown  [RTExpValue]
    onKeyPress  [RTExpValue]
    onKeyUp  [RTExpValue]
    onMouseDown  [RTExpValue]
    onMouseMove  [RTExpValue]
    onMouseOut  [RTExpValue]
    onMouseOver  [RTExpValue]
    onMouseUp  [RTExpValue]
    onSelect  [RTExpValue]
    style  [RTExpValue]
    searchCombo - Renders all the needed fields for searching with a comboBox. Hides the searchfieldName stuff from the JSP developer. Rewrites the input field with the old value. Can be used together with tableData, queryData or staticData.

    example of result: <input type="hidden" name="searchalgo_0_1" value="weakEnd"/> <input type="hidden" name="searchmode_0_1" value="AND"/> <select name="search_0_1"> <option>from datatag</option> </select>

    Attribute NameDescription
    fieldName

    Name of the field in the table for which the searching should be done

    [Required][RTExpValue]
    id

    expose id, enables interaction with JavaScript (not supported by all browsers!)

    [RTExpValue]
    searchAlgo

    The search algorithm. Default: sharp

    [RTExpValue]
    searchMode

    The search mode. Default: and

    [RTExpValue]
    customEntry

    Allows an additional (independant) entry into the select list
    Arguments to this tag are as follows:
    Key,Description,boolean (default selection?)

    [RTExpValue]
    selectedIndex

    Index that should be selected as default when form redered the first time

    [RTExpValue]
    compareWith

    if set to "index" the index value will be used to compare against the selected value. if set to "value" the value value will be used to compare against the selected value. if set to "list" the index of the list will be used to compare against the selected value default is "index".

    [RTExpValue]
    size

    how many rows should the select box have

    [RTExpValue]
    onBlur  [RTExpValue]
    onChange  [RTExpValue]
    onClick  [RTExpValue]
    onDblClick  [RTExpValue]
    onFocus  [RTExpValue]
    onKeyDown  [RTExpValue]
    onKeyPress  [RTExpValue]
    onKeyUp  [RTExpValue]
    onMouseDown  [RTExpValue]
    onMouseMove  [RTExpValue]
    onMouseOut  [RTExpValue]
    onMouseOver  [RTExpValue]
    onMouseUp  [RTExpValue]
    onSelect  [RTExpValue]
    style  [RTExpValue]
    searchCheckBox - Renders a CheckBox for searching. The field value wich is searched for is the value of the value attribute. Renders all the needed fields for searching. Hides the searchfieldName stuff from the JSP developer.

    example of result:

    Attribute NameDescription
    fieldName

    Name of the field in the table for which the searching should be done

    [Required][RTExpValue]
    searchAlgo

    The search algorithm. Default: sharp

    [RTExpValue]
    searchMode

    The search mode. Default: and

    [RTExpValue]
    value

    The value to search for

    [Required][RTExpValue]
    checked

    If set to true the ceckbox will be checked during rendering

    [RTExpValue]
    id

    Renders HTML id field

    [RTExpValue]
    onBlur  [RTExpValue]
    onChange  [RTExpValue]
    onClick  [RTExpValue]
    onDblClick  [RTExpValue]
    onFocus  [RTExpValue]
    onKeyDown  [RTExpValue]
    onKeyPress  [RTExpValue]
    onKeyUp  [RTExpValue]
    onMouseDown  [RTExpValue]
    onMouseMove  [RTExpValue]
    onMouseOut  [RTExpValue]
    onMouseOver  [RTExpValue]
    onMouseUp  [RTExpValue]
    onSelect  [RTExpValue]
    style  [RTExpValue]
    filter - Create a set of sql filter conditions, letting user select which one will be applied.

    A filter tag contains one or more filterCondition tag. Each filterCondition represent a sql condition and is identified by its label. In the body of the filterCondition tag there is the piece of SQL code that we want to insert in the where clause, the character ? act like a placeholder, so a ? in the sql code will be substituted with the some user input. To tell the system what type of user input we want, the last tag is used, the filterValue tag. Each ? found in body will be subsituted by its corresponding filterValue tag. With the "type" attribute of this tag you can select the input more. Selecting "text", a filterValue will render an html input tag, with "select" you'll have an html select, and so on. An example is like this:

    							<db:filter> <db:filterCondition
    							label="author name like"> NAME LIKE %?%
    							<db:filterValue/>
    							</db:filterCondition>
    							<db:filterCondition label="ID > V1 AND ID
    							< V2"> AUTHOR_ID >= ? AND AUTHOR_ID <=
    							? <db:filterValue label="V1"
    							type="numeric"/> <db:filterValue
    							label="V2" type="numeric"/>
    							</db:filterCondition>
    							<db:filterCondition label="author equal
    							to"> NAME = ? <db:filterValue
    							type="select"> <db:queryData name="q1"
    							query="select distinct name as n1, name as
    							n2 from author where AUTHOR_ID < 100
    							order by name"/> </db:filterValue>
    							</db:filterCondition>
    							<db:filterCondition label="now is after
    							date"> CURRENT_DATE > ? <db:filterValue
    							type="date" useJsCalendar="true" />
    							</db:filterCondition>
    							<db:filterCondition label="filter without
    							user input"> AUTHOR_ID > 10
    							</db:filterCondition> </db:filter>
    						

    This structure will be rendered as a html select element to select the condition the you want to apply. On the onchange event there is a submit, so the page reload with the input elements of the condition that you have selected. After all input elements, there are two buttons, one to apply the condition, one to unset the current applied condition.

    Attribute NameDescription
    disabledCaption

    used to override the label of the main select's first option element

    [RTExpValue]
    setCaption

    caption of the SET button

    [RTExpValue]
    unsetCaption

    caption of the UNSET button

    [RTExpValue]
    styleClass

    CSS stylesheet class to be applied. This is done adding a SPAN element that contains the text.

    [RTExpValue]
    title

    this defines the "title" attribute for the HTML4 tag.

    [RTExpValue]
    size

    Number of rows of select element

    [RTExpValue]
    setStyleClass

    CSS stylesheet class to be applied to the SET button. If not provided, the styleClass attribute is used.

    [RTExpValue]
    unsetStyleClass

    CSS stylesheet class to be applied to the UNSET button. If not provided, the styleClass attribute is used.

    [RTExpValue]
    filterCondition - Holds an sql condition that has to be nested inside a DbFilterTag.

    A condition is specified as sql code in the body of the tag. The character ? is a placeholder for user's input substitution. Every char ? found in sql code is replaced with value evalutated from corresponding filterValue tag nested. So there must be as ? as filterValue tags.

    Attribute NameDescription
    label

    Label that identified the condition in the select list

    [Required][RTExpValue]
    filterValue - Map a placeholder (?) in sql code to an input tag. Used as nested tag inside filterCondition.

    Attribute NameDescription
    label

    label that will be rendered in bold before the input element

    [RTExpValue]
    type

    type of the input element that will be rendered, possible values are:

    text
    text input
    date
    input text for date type, a validation of the value will be done, and it supports the jscal object
    timestamp
    input text for timestamp type, a validation of the value will be done, and it supports the jscal object (it doesn't fit very well, anyway ...)
    numeric
    input text for number, a validation of the value will be done
    select
    render an html select element, filled with nested tags like queryData, staticData and so on.

    [RTExpValue]
    searchAlgo

    The search algorithm. possible values:

    sharp
    this is the default behavior, do nothing.
    weakStart
    like, % is added in front of value
    weakEnd
    like, % is appended to value
    weakStartEnd
    like, % is added in front of value and % is appended to value

    [RTExpValue]
    customEntry

    Allows an additional (independant) entry into the select list<br/> Arguments to this tag are as follows:
    Key,Description,boolean (default selection?)

    [RTExpValue]
    selectedIndex

    Index that should be selected as default when form is rendered the first time

    [RTExpValue]
    useJsCalendar

    Place small calendar icon after input field. Clicking that icon will popup a JavaScript calendar that can be used to set a new value for the field. Some preparations have to be done, the calendar must be copied into the web applications and must be included in current page. See dbforms manual for details.

    [RTExpValue]
    jsCalendarDateFormat

    Subpatterns inside date formats have sometimes different meanings in Java and inside JavaScript calendar. For some date formats it may be neccessary to explicitely set a date format to the calendar that corresponds to the used date format inside dbforms application. See dbforms manual for details.

    [RTExpValue]
    size

    Number of rows of select element

    [RTExpValue]
    styleClass

    CSS stylesheet class to be applied. This is done adding a SPAN element that contains the text.

    [RTExpValue]
    title

    this defines the "title" attribute for the HTML4 tag.

    [RTExpValue]
    redirectURL - force a redirect to a DbForms View

    generates a link to a DbForms View

    Attribute NameDescription
    href

    the url of the JSP file representing the view

    [Required][RTExpValue]
    tableName

    the url of the table the view represents

    [Required][RTExpValue]
    position

    optional: the position to navigate to within table "tableName"

    for backwards compatibility is the same as destPos!

    [RTExpValue]
    parentField

    used if parentTable is different to tableName: field(s) in the main form that is/are linked to this form

    [RTExpValue]
    childField

    used if parentTable is different to tableName: field(s) in this form that is/are linked to the parent form

    [RTExpValue]
    destPos

    a value indicating the row to navigate to. Position strings are used as request parameters allowing the framework to keep track of the position the user comes from or goes to. This string is structured as follows:

    fieldId : fieldValueLength : fieldValue

    It is important to note that if multiple keys exist in the definition of the table, your position string must includes values for each key. (separated by dashes (-))

    Example:

    <! Jump to another JSP, specify position using multiple keys-->
    <db:gotoButton caption="View Sample Details" destination="/viewSample.jsp"
    destTable="Sample" destPos="1:6:widget-3:2:23"/>

    [RTExpValue]
    keyToDestPos

    a key indicating the row to navigate to.

    Example:

    <! Jump to another JSP, specify position through a key -->
    <db:gotoButton caption="View Sample Details" destination="/viewSample.jsp"
    destTable="Sample" keyToDestPos="k_1_1@root"/>

    [RTExpValue]
    keyToKeyToDestPos

    a key to the key indicating the row to navigate to. For each record in the result-set, the associatedRadio tag generates a key reference which can be used to retrieve a position string.

    Example:

    <!for each record, generate a key to the position string -->
    <db:body><db:associatedRadio name="test"/></db:body>

    <db:footer>
    <! Jump to another JSP, specify position (get second record using appropriate key!)-->
    <db:gotoButton caption="View Sample Details" destination="/viewSample.jsp"
    destTable="Sample" keyToKeyDestPos="test"/>

    Check "customerlist.jsp" in example!

    [RTExpValue]
    singleRow

    if set to true, only one row of data will be fetched. default is false, so that all rows of data will be fetched and the requested record will be set as actual record.

    [RTExpValue]
    setCustomFormatter - Register a Custom Formatter for later use

    The registered class must implement the org.dbforms.interface.ICustomFormat interface. A new instance of the object will be instantiated and initialized with the 'arg' value, this instance will be given the name 'name'. The name exists in the session space. Other tags that utilize the custom formatter will use the attribute customFormatter='xyz', where 'xyz' is the name registered. Multiple instances of the same object can exist with different names and initial values for arg.

    At runtime the class's setLocale() method will be called. Then the sprintf(Object[] data) method will be called, data will be an array of 3 values. data[0] = string of text (i.e. what would normally be displayed), data[1] is the current field of type Field, and data[2] is the invoking tag of type Tag. The methods should check for null values in the input.

    Attribute NameDescription
    name

    name to use, other tags will use this as the value for the customFormatter attribute

    [Required][RTExpValue]
    className

    FQ ClassName to load

    [Required][RTExpValue]
    arg

    optional: arg passed to instance

    [RTExpValue]
    textFormat - this tag formats a value with dbforms format settings

    either the contextVar -OR- type and value must be set! This allows you to calculate a value in your jsp, store this into the pageContext or pass in a value directly and then use the textFormat tag to format it with the settings used in dbforms - with locale support.

    Attribute NameDescription
    type

    Fieldtype. Must match a dbforms field type declaration

    [RTExpValue]
    value

    The value which should be formatted

    [RTExpValue]
    contextVar

    Name of a context variable which should be formatted

    [RTExpValue]
    pattern

    When dealing with numeric or date/time values, you could use the Java API to format the output of the text field expressions yourself using the format attribute. But there is a more convenient way to do it: by using the pattern attribute. The value you should supply to this attribute is the same that you would supply if it were for you to format the value using either the java.text.DecimalFormat class or java.text.SimpleDateFormat class, depending on the type of value to format. In fact, what the engine does is to instantiate the java.text.DecimalFormat class if the text field expression returns subclasses of the java.lang.Number class or to instantiate the java.text.SimpleDataFormat if the text field expression return java.util.Date or java.sql.Timestamp objects. For more detail about the syntax of this pattern attribute, check the Java API documentation for those two classes: java.text.DecimalFormat and java.text.SimpleDateFormat.

    [RTExpValue]
    customFormatter

    The name of a formatting instance registered previously by using the setCustomFormatter tag

    [RTExpValue]
    pieData - This datatag generates a cewolf DatasetProducer with PieDataSet included. Data is taken from the dbforms resultsetvector.

    You need to install batik jars to use this tag! You can copy them from the bookstore example!

    Attribute NameDescription
    categoryField

    Name of the field in the resultsetvector which should be used as the key in the pie dataset.

    [Required][RTExpValue]
    dataField

    Name of the field in the resultsetvector which should be used for getting the values for the pie dataset. This field must be a numeric value!

    [Required][RTExpValue]
    categoryData - This datatag generates a cewolf DatasetProducer with CategoryDataSet included. Data is taken from the dbforms resultsetvector.

    You need to install batik jars to use this tag! You can copy them from the bookstore example!

    Attribute NameDescription
    categoryField

    Name of the field in the resultsetvector which should be used as the category field in the dataset.

    [RTExpValue]
    seriesField

    Name of the field in the resultsetvector which should be used as the series field in the dataset.

    [RTExpValue]
    dataField

    Name of the field in the resultsetvector which should be used for getting the values for the dataset. This field must be a numeric value!

    [Required][RTExpValue]
    highLowData - This datatag generates a cewolf DatasetProducer with a OHCDDataSet included. This can be used to produce a HighLow plot. Data is taken from the dbforms resultsetvector.
    Attribute NameDescription
    timeField

    Name of the field in the resultsetvector which should be used for the x axis. This field must be a datetime value!

    [Required][RTExpValue]
    title

    The title for the series

    [RTExpValue]
    openField

    The field for the open value

    [RTExpValue]
    highField

    The field for the high value

    [Required][RTExpValue]
    lowField

    The field for the low value

    [Required][RTExpValue]
    closeField

    The field for the close value

    [RTExpValue]
    timeSeriesData - This datatag generates a cewolf DatasetProducer for a timeSeriesDataSet included. Data is taken from the dbforms resultsetvector. Inside this tag must be at least one timeSeriesField tag defined which will helds the information for the values
    Attribute NameDescription
    timeField

    Name of the field in the resultsetvector which should be used for the x axis. This field must be a datetime value!

    [Required][RTExpValue]
    rendererclass

    classname of an specialized XYItemRenderer. During construcution this renderer will be created and used instead of the cewolf default renderer.

    [RTExpValue]
    timeSeriesField - This tags defines the fields for a cewolf timeSeries data tag
    Attribute NameDescription
    fieldName

    Name of the field in the resultsetvector which should be used for the y axis. This field must be a numric value!

    [Required][RTExpValue]
    title

    The title for the series

    [RTExpValue]
    color

    the color of the series

    [RTExpValue]
    property - Name/value-pair to paramterize a surrounding tag whose handler must implement the IPropertyList interface.
    Attribute NameDescription
    name  [Required][RTExpValue]
    value  [Required][RTExpValue]
    presetFormValues - Register a custom handler which is called before the filter values are retrieved, just after calling the table before select handler. This handler can be used to preset form values

    The registered class must implement the org.dbforms.interface.IPresetFormValues interface. A new instance of the object will be instantiated and initialized with the attribute list.

    Attribute NameDescription
    className

    ClassName to load

    [Required][RTExpValue]