Ftsearch multiple fields with AND

HCL Domino Domino Forum
1

Set dc = db.FTSearch( ("FIELD dtitle CONTAINS " & tTitle And “FIELD dauthor CONTAINS” & tAuthor(0)), 0)

With this formula, I got type mismatch, but I separate the script to run for each field, it didn’t have error. Anything wrong with this. Please help. Thanks

Elaine

2

Subject: Ftsearch multiple fields with AND

You have to make the AND word part of the string like Set dc = db.FTSearch( (“FIELD dtitle CONTAINS " & tTitle & " And FIELD dauthor CONTAINS” & tAuthor(0)), 0)

3

Subject: RE: Ftsearch multiple fields with AND

Hi Marcel

It works. Thanks for saving my hard time.

Elaine