FT Search in 6.01

HCL Domino Domino Forum
1

I have some LotusScript code (below), which ran perfectly on Domino 6.0, since upgrading to 6.01 it does not produce any results.

The index had been deleted and recreated, but still nothing. If I run the same code on my 6.01 workstation it works. If I run it from a Domino 6.0 server it works. If I run it when the DB is on a 6.01 Win/32 server it gives no results. A Linux server running 6.01 does give the results.

Query$=|FIELD FORM="History" AND FIELD CAMPDESC="|+Campaign+|"|



Call db.UpdateFTIndex(True)  		'Update Index



Set SearchCollection=db.FTSearch (Query$,0)



If SearchCollection.Count <=0 Then

	Msgbox "There are no contacts for this campaign",16,"Mail Merge"

Else

	REM now open Excel and create the workbook

SearchCollection.Count always returns 0 on a Domino 6.01 server but 510 as the count on a workstation or 6.0 server

Bug in Domion 6.01 for Win/32?

Please help!

Thanks.

2

Subject: That proves it…

Linux IS better than windows!

(sorry I didn’t have an answer for you)

3

Subject: FT Search in 6.0.1

After upgrading from R5 to 6.0.1, several databases failed to index.Deleting and re-creating the index did not help until I removed the INI setting FT_LIBNAME=

4

Subject: RE: FT Search in 6.0.1

No FT_LIBNAME in my notes.ini on the server!

5

Subject: RE: FT Search in 6.0.1

Did anyone get this bit of code to work under r6.01 Server?

I have some similar code that updates the index in LotusScript, and it doesn’t work any more in r6, but ran fine under r5.x

It is lifted straight out of the help file under NotesDatabase.UpdateFTIndex

Any suggestions? DB Index is “Immediate”

Mark Haller

LogicSpot

UK