developerWorks  >  Lotus  >  Forums & community  >  Notes/Domino 4 and 5 Forum

Notes/Domino 4 and 5 Forum

developerWorks




@Implode formula - help needed
Swarna ss 09/05/2007 06:50 AM
Domino Designer -- @Formulas 5.0.7 Windows XP


Hi,

I have few fields on the form and based on the values entered on any of those fields i need to build a full Text search string.

I browsed the forum and found some help in building the Full Text search. I referred to the following code:

http://www.ibm.com/developerworks/lotus/library/ls-Ad-hoc_Query_Tool/

Here in the example, it says that Syntaxlist is a concatenation of the 3 fields mentioned in the example.

I have 10 such fields and I tried to concatenate them as a + b + c + d + e + f + g + h + i + j.

I get the result as abcdefghij (assuming field a contains value a and so on..)

I am trying to build the search string using @implode function.

@Implode(Syntaxlist, " AND " )

The result is still abcdefghij (without any ANDs).

Can someone tell me where I am going wrong?

Any help on this is greatly appreciated as I am stuck at this point.

Thanks and regards.

Go back