Combobox, dblookup & blank

HCL Domino Domino Forum
1

Hi,

I searched through forums for possible solution and couldn’t find one. So if already posted please excuse me.

I have combobox which gets value from view. I’m trying to display the values along with blank/space in combobox. Below is the formula which is coded

" " : @DbLookup(“”:“”;“”:“”;“vwITManager”;“IT Manager”;2) + “|” + @DbLookup(“”:“”;“”:“”;“vwITManager”;“IT Manager”;2)

The output for dblookup is like

A | 1

B | 2

C | 3

So when I select B from combobox I get value as 3 and if it blank then I get 1. So am I missing something.

2

Subject: RE: combobox, dblookup & blank

Your problem is that : is a higher-precedence operator than +. Use parens to control the order of evaluation. You might also make your first choice something like “-none-|” instead of " ".