Why DB.ftsearch retreiving every document in database ?

Hi ,

I have developed a website using Lotus Notes. The "Seach" part in this website is bit difficult part for me. I have developed a lotus script agent which gathers the result contents and populate in the search form on webqueryopen event.

I also have a profile document which has many search parameters defined such as statistic database,no. of results per page etc.

Now using these parameters I am performing a db.ftsearch , which results documentcollection. I then go through these documents , get the scent and then generate html and store that in a string. Result is working absolutely fine in most of the cases except few.

If i search for "max","mon","time" then everytime it results every document in search result. Similarly if i seach for my own name (first name), or the manager's first name (as listed in database ACL) , again i get all documents. say 124 documents every time.

I searched for "date" and the query failed.

To be more precise, I have a field "PageStatus" set to "web" when document is online. That is also a part of search query.

Queries and the resulted collection count are as following :
(([PageStatus] = Web)) AND ((max)) - col.Count=128
(([PageStatus] = Web)) AND ((mon)) - col.Count=128
(([PageStatus] = Web)) AND ((frank)) - col.Count=128
(([PageStatus] = Web)) AND ((technology)) - col.Count=1

and so on ...

Could you please guide me if I am wrong somewhere ? Start Free Trial