Help with dblookup on an xpage

Can someone steer me in the right direction?

I have two combobox’s on my xpage. The first does a dbcolumn to a set of documents in the database. This works fine. The second does a dblookup to another set of documents based on the value selected in the first combobox (at least this is what I want it to do). I cannot seem to get the dblookup to work using the value selected from the dbcolumn.

The first combobox is set to do a partial update on the second combobox when the value is changed.

The formula for the values of the second combobox is:

str1 = document1.getItemValueString(“Title”);

@DbLookup(“DB1.nsf”, “(LUCategory)”, str1, 2);

Any help would be appreciated :slight_smile:

Subject: I think there was a bug which is fixed (but not available for everyone)

Lets hope to see shipping code, soon.

Subject: I am not aware of an error in this area, which is still in CD12…

Actually reading your post again, I think I gave you wrong information.

If you do your partial refresh, I would consider something like @now in the refreshed area, to see if it refreshes at all.

Subject: What version?

I have the CD12 code and still continue to have this issue. Any ideas if it is suppsed to be fixed in this code release?

Many Thanks

Subject: Seems to be a problem with combo boxes only

I am facing a similar problem - trying to update a combobox’s options based on another value (radio buttons).

The combobox’s options will only change if I do a full refresh, but the radio button then also loses its value, reverting back to the default.

If I put everything in a panel and do a partial refresh (of the panel), the combobox’s options do not change. However, if I add a computed text field or a radio group to the panel, their values do change.

That seems like a bug to me.

Karl

Subject: Try this…

I think you might need a onChange event to refresh the xpage to populate the second combo box.

I’ve written the following wiki article on this…

http://www-10.lotus.com/ldd/ddwiki.nsf/dx/02102008091536PHABPL.htm