Help with db.ftsearch with lotus script

HCL Domino Domino Forum
1

formatting my query for a full text returns:
Notes error: Query is not understandable ([Body]“String1” AND “String2”)

how can I properly format a query for FTSearch… the online help is useless in this scenario…

dim searchText1 as string
dim searchText2 as string
dim condition as string (for string return with a radio button… AND OR )
dim query as string
dim test as string

searchText1 = uidoc.FieldGetText (“stringtextfield1”)
searchText2 = uidoc.FieldGetText (“stringtextfield2”)
condition = uidoc.FieldGetText(“condition”)

'searchtext1 returns “String1”
'searchtext2 returns “String2”
condition returns “AND” or a “OR” depending on RB choice.

test = |“| & searchText1 & |” | + condition + | “| & searchText2 & |”|
query = |[Body]| & test

Set searchCollection = searchDB.FTSearch ( b_query, 0 ) << error

I assume the query building problem is at “test =” , but I don’t know. I’ve tried so many different way, I’m burnt.

Can anyone advise please?

2

Subject: You need an operator

([Body]“String1” AND “String2”)

will not compile but

([Body] = “String1” AND [Body] = “String2”)

will.

and the operator CONTAINS is functionally equivalent.