Not a concatenate | symbol

HCL Domino Domino Forum
1

Dear all,

table := “OFFERSTATUS”;

numCol := 3;

numcolAlias :=2;

val1:=@DbLookup(“” : “NoCache”; Serveur :BReference; “KeyWords”; table; numCol);

val2:=@DbLookup(“” : “NoCache”; Serveur :BReference; “KeyWords”; table; numcolAlias);

val:=val1+“|”+val2;

val

This code fetch a value e.g. won|1 but i have use “|” for concatenate val1 and val2 this is only dispaly val1 value. not dispaly | and val2 value wat a solutions

2

Subject: Not a concatenate | symbol

Use “:”, which is the concatenation operator instead of “|” symbol

3

Subject: Not a concatenate | symbol

What you are seeing is the way things are supposed to work. When a choice value in a keywords-type field (listbox, combobox, dialog list, checkbox, radio) looks like this:

Some Value|Another Value

only “Some Value” appears in the UI field, and only “Another Value” will be stored in the document if the user chooses “Some Value” from the list. This allows a couple of things to happen. First, it is easier to create multilingual databases since most of the code you can create for a Notes database is concerned with what is stored in the back-end document, not what appears in the UI. You can, therefore, change what the user sees without having to recode agents and so forth. Secondly, it allows you to modify the business terminology, again without having to recode the database in order to allow for the new (and just as temporary) fad buzzword of the day.