Db.ftsearch syntax when value contains parentheses

HCL Domino Domino Forum
1

Hi there!

I’m trying to perform the following search, but I’m getting an error I suspect because of the parentheses (BSE). Is there any way to get around this?

db.FTSearch(“Bovine Spongiform Encephalopathy (BSE)”, 0)

Thanks!

Gérald

2

Subject: Try making it a phrase: db.FTSearch(|“Bovine Spongiform Encephalopathy (BSE)”|, 0)

3

Subject: Try making it a phrase: db.FTSearch(|“Bovine Spongiform Encephalopathy (BSE)”|, 0)

Hi Bill:

Thanks for your response. It worked!

So how would one do it using a field and variable? I tried this, but it doesn’t work:

dbGlobal.FTSearch(“[ItemSubjectMatter]=|” + doc.ColumnValues(1) + “|”, 0)

Your help is greatly appreciated.

Gérald

4

Subject: This should do it: dbGlobal.FTSearch(|[ItemSubjectMatter]= “| + doc.ColumnValues(1) + |”|, 0)

5

Subject: Re: This should do it: dbGlobal.FTSearch(|[ItemSubjectMatter]= “| + doc.ColumnValues(1) + |”|, 0)

Thanks, Bill!

That did the trick.

Your help is greatly appreciated.

Gérald