Represents a drop-down list or listbox whose options are automatically populated by a specified view or formula. The value that is assigned to each option tag that is generated is the UNID of the corresponding document. The drop-down list with all its options displays in edit mode. In read mode, the body of only the currently selected option displays.

The dbselect tag can also be used to create a standard HTML <select> tag. If you use it this way, the itemname and defaultvalue attributes are ignored. Also, the size of the drop-down list created in read mode is determined by the value supplied in the HTML "size" attribute. Supplying the size attribute indicates to display the options in a listbox, but includes the readonly HTML attribute in the select tag to prohibit the options from being changed.

Contexts

Valid in:

form

option, dbfill

<domino:dbselect
name="web control name"
itemname="name of the item in the document"
view="database view to retrieve data from"
query="search query string"
key="lookup value to search for in a sorted column in the view"
max="number"
dbserver="server database resides on"
dbname="database name"
user="login information"
password="password associated with user"
category="category name"
displayitem="item to use to display an option tag"
valueitem="item to use to represent the value of an option tag"
host="CORBA server name"
format="options display format"
formula="Notes formula"
debug="true|false"
onfailure="inline|exception"
time="true|false"
The standard HTML tag attributes listed below>

category

Filters out a subset of documents that fall under the specified category of the view. You cannot supply a value for this attribute if you supply a value for the key and query attributes; these attributes are mutually exclusive. Optional.

Name of the database that contains the view entries making up the options list. Optional.

Name of the server hosting the database specified in the dbname attribute. If null, defaults to the local server. Optional.

Name of the item to display to represent a generated option tag. Required.

Format to use to display the selected option in display mode, as specified by the keywords supplied. See Formatting JSP content for a list of available formatting keywords. If not specified, turns the result into a string using the Java toString() method. Optional.

Notes formula that generates a display/value list that is used to derive the display and value for the generated option tags. If a value contains an alias, the value is displayed and the alias is passed as the value of the generated tags. If specified, this attribute overrides the view, query, key, displayitem, and valueitem attributes. Optional.

Name of the Domino CORBA (Common Object Request Broker Architecture) server to use to host the back-end classes. If specified, forces a CORBA session. If not specified, a Domino server must be running locally on the same machine that is running the JSP Web container. Default is null which creates a local, non-CORBA, session. Optional.

Name of the item in the document. This attribute is useful if the itemname and name of the control on the page need to be different, due to invalid characters in the itemname, for example. By default, this attribute equals the value of the name attribute. Optional.

Specific value to search for in a sorted column on the view specified in the view attribute. Generates a subset of documents that contain the specified value. You cannot supply a value for this attribute if you supply a value for the category attribute; these attributes are mutually exclusive. Optional.

Maximum number of documents to generate option tags for and to display in the generated drop-down list. Optional.

Name of the Web control. Required.

Password associated with user specified in the user attribute. Optional.

Full-text searches the database for documents meeting the specified criteria. Creates a subset of documents from which to generate the drop-down list. If you use this attribute in conjunction with the view attribute, searches only the specified view, instead of the entire database. You cannot supply a value for this attribute if you supply a value for the category attribute; these attributes are mutually exclusive. Optional.

Login information for the session. If this tag is being used in the context of a session tag, the value of this attribute is ignored. Optional.

Name of the item to use to represent the value of a generated option tag. By default, the UNID of the document is generated as the value. Optional.

Name of the view to access documents from. The view must have at least one sorted column in order to use the key attribute to perform a lookup and generate a subset of documents containing a specific value. Alternatively, you can search the entire database using the query attribute. If you specify a value for this attribute in addition to the query attribute, searches the specified view only. Optional.

HTML Attributes

Domino supports the following HTML tag attributes. See the Common HTML tag attributes section for their definitions.

accesskey

align

datasrc

disabled

multiple

onafterupdate

onbeforeupdate

onblur

onchange

onclick

ondblclick

ondragstart

onfocus

onhelp

onkeydown

onkeypress

onkeyup

onmousedown

onmousemove

onmouseout

onmouseover

onmouseup

onresize

onrowenter

onrowexit

onselectstart

size

tabindex

The Domtags tag library

Glossary