This is a repost of an earlier question about the correct usage of dbselect and dbfill tags. Any help would be much appreciated
Thanks
Using the Domino Toolkit for Websphere I am trying to duplicate the following functionality and failing
A user selects a value from a keyword field where the options are derived from a view column (a simple @DbLookup). Values of some other
fields are then computed (again using @Dblookup) based on the selected keyword.
So for instance a user selects a sub category, and the associated category and Program Manager are automatically computed.
This is what I did :
<domino:dbselect name=“SubCat” displayitem=“SubCat” view=“ViewSubCatByNo”>
<domino:dbfill target=“SubCatDesc” dbfield=“SubCatDesc” />
<domino:dbfill target=“CtgCode” dbfield=“CtgCode” />
<domino:dbfill target=“CatDesc” dbfield=“CatDesc” />
</domino:dbselect>
In this case
In read mode the SubCat field displays BLANK instead of the existing value.
In edit mode it DOES NOT default-select the existing value and infact defaults to ‘Select’.
But on selection of a Sub Category it DOES compute the associated fields specified in the dbfill tag.
If I add the attribute - valueitem=“SubCat” in my dbselect tag,
<domino:dbselect name=“SubCat” displayitem=“SubCat” valueitem=“SubCat” view=“ViewSubCatByNo”>
In this case
In read mode the SubCat field DOES display the existing value (for some reason preceded by a bullet)
In edit mode it DOES default-select the existing value.
But on selection of a Sub Category it CRASHES!
Can somone please let me know what I am doing wrong here? The desired functionality would be:
In read mode the SubCat field DOES display the existing value (for some reason preceded by a bullet)
In edit mode it DOES default-select the existing value.
But on selection of a Sub Category it DOES compute the associated fields specified in the dbfill tag.
Any help would be much appreciated
TIA