Setting values in Dialog list

HCL Domino Domino Forum
1

Hi,I am new in Lotus Notes. pls help me with this.

I have one dialog list control on web page. I want to set value for the same.

Formula I am using for choices is as follows:

“-----” :@DbColumn ( “” : “NoCache”; “” : “”; “lookupview”; 2 ) | “-----” :@DbColumn ( “” : “NoCache”; “” : “”; “lookupview”; 1 )

But its giving me error :

Lotus Notes Exception - Incorrect data type for operator or @Function: Number expected

I am nt sure how to set values in Dialoglist using formula.

please help me out. Thanks in advance

2

Subject: RE: Setting values in Dialog list

The | operator (“or”) requires two numeric operands, and you are giving it two strings – hence the error.

If you meant to concatenate the values in two lists with the character “|” between them, you should use

listA + “|” + listB

However, it is pretty inefficient to use @DbLookup twice to the same view. I suggest you change the view so that you can pull the value you want from a single column. In other words, the view formula should be

fieldA + “|” + fieldB

so that you can do one @DbLookup and get the exact values you need.

Also, please reconsider your use of NoCache. Do you really need this data to not be cached? Because caching is a lot faster. And use “” to specify the current database, not “”:“”

So then your keyword formula might be:

“—|” : @DbColumn ( “” ; “”; “lookupview”; 2 )

3

Subject: RE: Setting values in Dialog list

Thanks a lot. It helped.