dbform - a database application form (root element of a JSP view)
Tag name Description 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. textArea renders a HTML TEXTAREA element textAreaForBlobs renders 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. linkURL generates a link to a DbForms View position element to be embedded inside a linkURL-element insertButton this tag renders an INSERT-button deleteButton this tag renders a DELETE-button updateButton this 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 gotoButton button for jumping to other jsp base renders 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) style generic style tag templateParam param 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. redirectURL force 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
header - this tag renders a Header-tag. It should be nested within a dbform-tagthis is the root element of a data manipulation form
Attribute Name Description 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:
[RTExpValue]
- searchTag contains a value
- the filter attribute (dbforms tag) contains a value
- a filter tag is specified
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();
[RTExpValue]
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>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:
important:
- "id, name desc"
- "id"
- "id asc"
- "firstname asc, lastname desc"
[RTExpValue]
- 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)
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 ISNULLNOTISNULL is not null aField NOTISNULLBy 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 flexibilitythis attribute was added in release 0.9
[RTExpValue]onSubmit
JavaScript event handler executed before the form is submited. If the event handler returns FALSE,
[RTExpValue]
the form will not be submitted. When the result is TRUE, the form will be submittedautocomplete
if the autocomplete value is specified then the attribute is inserted in the form tag.
[RTExpValue]
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" ... >
body - this tag renders a Body-tag. It should to be nested within a dbform-tag.
this tag renders a Header-tag. Itshould to be nested within a dbform-tag.because this tag
This tag has no attributes.
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.
footer - the footer grouping tag. it is supposed 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 Name Description allowNew by default this is "true" - if so, the body is rendered at least 1 time,
[RTExpValue]
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"
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)
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.
dateLabel - label - a tag for date data PRESENTATION, NOT data EDITING (=> can never be used as input field)label - can never be used as input field
Attribute Name Description 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]
dataLabel - label - a tag for data PRESENTATION, NOT data EDITING (=> can never be used as input field)
Attribute Name Description 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]
textField - this tag renders a dabase-datadriven TEXTFIELD, which is an active element - the usercan change data
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 Name Description 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]
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.i/o text field
Attribute Name Description 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]
textArea - renders a HTML TEXTAREA element
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 Name Description 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]
textAreaForBlobs - renders a HTML TEXTAREA elementi/o textarea
Attribute Name Description 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:
[RTExpValue]
- "virtual" - text get wrapped optically
- "phyiscal" - text get wrapped optically and physically (line breaks)
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]
tableData - external data to be nested into radio, checkbox or select - tag!(useful only in conjunction with radio, checkbox or select - tag)i/o textarea for character diskblobs. use it if you want users to edit files using textareas
Attribute Name Description 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:
[Required][RTExpValue]
renderBody attribute must be set to true.
fieldPath is of type DISKBLOB.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:
[RTExpValue]
- "virtual" - text get wrapped optically
- "phyiscal" - text get wrapped optically and physically (line breaks)
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]
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 Name Description 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.
[RTExpValue]
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.PrintfFormatforeignTable 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]
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 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 Name Description 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.
[RTExpValue]
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.PrintfFormatforeignTable 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]
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 (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 Name Description 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.
[RTExpValue]
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.PrintfFormatquery
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
[Required][RTExpValue]
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 boxdisableCache Each query is executed independently
[RTExpValue]
staticDataItem - data to be nested into staticData element! (see description of staticData for further details)
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 Name Description 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]
getConnection - Allows other tags (or scriptlets) to obtain a database connection object using the same settings found in dbForms-config.xml
Attribute Name Description key [Required][RTExpValue] value [Required][RTExpValue]
setDataSource - Allows other tags (or scriptlets) to obtain a DataSource using the same settings found in dbForms-config.xml
Attribute Name Description 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
[Required][RTExpValue]
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 -->
dbConnectionName indicate which dbconnection object to user.
[RTExpValue]
file - this tag renders an UPLOAD-button for uploading files into BLOBs or DISKBLOBs
Attribute Name Description 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)
[Required][RTExpValue]
<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>
dbConnectionName indicate which dbconnection object to user.
[RTExpValue]
radio - renders a HTML RADIO element or a whole group of them
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 Name Description 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]
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 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 Name Description 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]
select - This tag renders a html SELECT element including embedded OPTION elements.
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 Name Description 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]
linkURL - generates a link to a DbForms View
select tag, may contain nested "DbData"-Tags (OR "dboption" tags, which are not implemented yet)
examples for DbData-Tags are tableData, queryData, staticDataExample:
<!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
- "dboption"- tags are expected for the next release
Attribute Name Description 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]
position - element to be embedded inside a linkURL-elementgenerates 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 Name Description 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-->
[RTExpValue]
<db:gotoButton caption="View Sample Details" destination="/viewSample.jsp"
destTable="Sample" destPos="1:6:widget-3:2:23"/>keyToDestPos
a key indicating the row to navigate to.
Example:
<! Jump to another JSP, specify position through a key -->
[RTExpValue]
<db:gotoButton caption="View Sample Details" destination="/viewSample.jsp"
destTable="Sample" keyToDestPos="k_1_1@root"/>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 -->
Check "customerlist.jsp" in example! [RTExpValue]
<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"/>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]
insertButton - this tag renders an INSERT-buttonexample:
<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 Name Description fieldName name of the key-field
[Required][RTExpValue]value value of the key field
[Required][RTExpValue]
deleteButton - this tag renders a DELETE-button
this tag renders an insert-button
the button is hidden if embedding form is not in insert mode
Attribute Name Description id expose id, enables interaction with JavaScript
[RTExpValue]flavor
styling of the button
choices:[RTExpValue]
- 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)
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]
updateButton - this tag renders an UPDATE-button
delete button
the button is hidden if embedding form is in insert mode
Attribute Name Description id expose id, enables interaction with JavaScript
[RTExpValue]flavor
styling of the button
choices:[RTExpValue]
- 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)
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]
navPrevButton - this tag renders a navigation button for scrolling to previous row(s) of the current table
update button
the button is hidden if embedding form is in insert mode
Attribute Name Description id expose id, enables interaction with JavaScript
[RTExpValue]flavor
styling of the button
choices:[RTExpValue]
- 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)
showAlways
If false (which is the default setting), the update button will be rendered
[RTExpValue]
only if resultset contains data
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]
navNextButton - this tag renders a navigation button for scrolling to next row(s) of the current tablenavigation button to scroll back
Attribute Name Description id expose id, enables interaction with JavaScript
[RTExpValue]flavor
styling of the button
choices:[RTExpValue]
- 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)
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:
[RTExpValue]
<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" />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 tablenavigation button to scroll to next dataset(s)
Attribute Name Description id expose id, enables interaction with JavaScript
[RTExpValue]flavor
styling of the button
choices:[RTExpValue]
- 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)
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:
[RTExpValue]
<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" />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 tablenavigation button to scroll to first dataset
Attribute Name Description id expose id, enables interaction with JavaScript
[RTExpValue]flavor
styling of the button
choices:[RTExpValue]
- 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)
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:
[RTExpValue]
<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" />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 datanavigation button to scroll to last dataset
Attribute Name Description id expose id, enables interaction with JavaScript
[RTExpValue]flavor
styling of the button
choices:[RTExpValue]
- 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)
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:
[RTExpValue]
<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" />disabledImageSrc see disabledBehaviour
[RTExpValue]disabledImageAlt see disabledBehaviour
[RTExpValue]disabledImageWidth see disabledBehaviour
[RTExpValue]disabledImageHeight see disabledBehaviour
[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 new, empty dataset
the "allowNew"-attribute of the parten "body"-tag MUEST NOT set to "false" in order to get this to work.
Attribute Name Description 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:[RTExpValue]
- 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)
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]
navReloadButton - this tag renders a navigation button for reloading and moving to the first row of the current table
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 Name Description 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:[RTExpValue]
- 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)
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]
gotoButton - button for jumping to other jspnavigation button for reloading and moving to the first dataset
Attribute Name Description id expose id, enables interaction with JavaScript
[RTExpValue]flavor
styling of the button
choices:[RTExpValue]
- 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)
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]
base - renders a HTML-BASE tag
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 Name Description id expose id, enables interaction with JavaScript
[RTExpValue]flavor
styling of the button
choices:[RTExpValue]
- 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)
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-->
[RTExpValue]
<db:gotoButton caption="View Sample Details" destination="/viewSample.jsp"
destTable="Sample" destPos="1:6:widget-3:2:23"/>keyToDestPos
a key indicating the row to navigate to.
Example:
<! Jump to another JSP, specify position through a key -->
[RTExpValue]
<db:gotoButton caption="View Sample Details" destination="/viewSample.jsp"
destTable="Sample" keyToDestPos="k_1_1@root"/>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>
[RTExpValue]
<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"/>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]
errors - Custom tag that renders error messages if an appropriate request attributehas been created.
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.
xmlErrors - Custom tag that renders error messages if an appropriate request attributehas been created. Used in conjuction with xml error managerrenders errors stored in request
Attribute Name Description 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]
hasError - This tag renders it's body if an error has occured
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 Name Description 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]
hasMoreRecords - Verifies if the number of records in the result set is larger then the number specifiedrenders errors stored in request
Attribute Name Description 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]
hasNoRecords - Verifies if the number of records in the result set equal 0
Attribute Name Description 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"
[Required][RTExpValue]
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>
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 Name Description 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
Attribute Name Description message
Message to display (see xml error manager)
[RTExpValue]
blobURL - This tag generates an URL pointing to a servlet downloading the DISKBLOB referenced by fieldName
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 difficultto 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 Name Description 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]
blobContent -
use cases:
- rendering an image: <img src="<db:diskblob fieldName="pic""/>" alt="a picture">
- rendering a (download-)hyperlink: <a href="<db:diskblob fieldName="pic""/>">download!</a>
Attribute Name Description fieldName
name of the field this tag references to
[Required][RTExpValue]defaultValue
default field name to use if the specified field is empty.
[RTExpValue]
"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)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]
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 Name Description fieldName
name of the field this tag references to
[Required][RTExpValue]dbConnectionName indicate which dbconnection object to user.
[RTExpValue]
style - generic style tag
Attribute Name Description fieldName
name of the field this tag references to
[Required][RTExpValue]
templateParam - param name
Attribute Name Description 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]
templateBasedir - writes out base dir of the current template
Attribute Name Description 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
[RTExpValue]
- 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!!
message - this tag renders a read-only text label. The data displayed is retrieved via a resource bundle and is locale-specific.
only used in template (_begin.jsp / _end.jsp) - definition files!
This tag has no attributes.
javascriptArray - This tag was added to allow the generation of a javascript array from EmbeddedData.
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 Name Description 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]
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 Name Description name name of the array.
[Required][RTExpValue]
pos - Renders a position to use with keyToDestPos. This is the same string wich would be used as value in the DbassociatedRadioTag.
Attribute Name Description event name of the event.
[Required][RTExpValue]value Condition in which to evaluate body. Default is set to true.
[RTExpValue]
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.
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"/>
- <input type="input" name="search_0_1"/>
Attribute Name Description 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]
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: <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 Name Description 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
[RTExpValue]
Arguments to this tag are as follows:
Key,Description,boolean (default selection?)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]
filter - Create a set of sql filter conditions, letting user select which one will be applied.
example of result:
- <input type="hidden" name="searchalgo_0_1" value="weakEnd"/>
- <input type="hidden" name="searchmode_0_1" value="AND"/>
- <input type="input" name="search_0_1"/>
Attribute Name Description 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]
filterCondition - Holds an sql condition that has to be nested inside a DbFilterTag.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 Name Description 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]
filterValue - Map a placeholder (?) in sql code to an input tag. Used as nested tag inside filterCondition.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 Name Description label Label that identified the condition in the select list
[Required][RTExpValue]
redirectURL - force a redirect to a DbForms View
Attribute Name Description 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:
[RTExpValue]
- 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.
searchAlgo The search algorithm. possible values:
[RTExpValue]
- 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
customEntry Allows an additional (independant) entry into the select list<br/> Arguments to this tag are as follows:
[RTExpValue]
Key,Description,boolean (default selection?)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]
setCustomFormatter - Register a Custom Formatter for later usegenerates a link to a DbForms View
Attribute Name Description 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-->
[RTExpValue]
<db:gotoButton caption="View Sample Details" destination="/viewSample.jsp"
destTable="Sample" destPos="1:6:widget-3:2:23"/>keyToDestPos
a key indicating the row to navigate to.
Example:
<! Jump to another JSP, specify position through a key -->
[RTExpValue]
<db:gotoButton caption="View Sample Details" destination="/viewSample.jsp"
destTable="Sample" keyToDestPos="k_1_1@root"/>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 -->
Check "customerlist.jsp" in example! [RTExpValue]
<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"/>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]
textFormat - this tag formats a value with dbforms format settings
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 Name Description 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]
pieData - This datatag generates a cewolf DatasetProducer with PieDataSet included. Data is taken from the dbforms resultsetvector.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 Name Description 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]
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 Name Description 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]
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.You need to install batik jars to use this tag! You can copy them from the bookstore example!
Attribute Name Description 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]
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 Name Description 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]
timeSeriesField - This tags defines the fields for a cewolf timeSeries data tag
Attribute Name Description 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]
property - Name/value-pair to paramterize a surrounding tag whose handler must implement the IPropertyList interface.
Attribute Name Description 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]
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
Attribute Name Description name [Required][RTExpValue] value [Required][RTExpValue]
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 Name Description className ClassName to load
[Required][RTExpValue]