I'm in a bit of a fix here.
I have a custom dialog box in which users can specify a number of search parameters. The users simply input data into fields, and then I have LS code that takes the data and parses it to create a search string. That search string is applied as follows :
collection = database.FTSearch(searchstring,maxdocs)
The issue I have is that when the code executes, there are no documents returned by the search (the collection is empty - count = 0), whereas if I type the same search string into the Search box, a half-dozen docs DO show up.
An example of search is this :
FIELD Status="2" & FIELD Subject="execute"
In this case, if the status field is 2 and the Subject field contains the word "execute", the doc should be returned.
There are 7 docs that correspond to this criteria, as using this string in a manual search confirms.
When this same search string is applied to the FTSearch method, the collection turns up empty.
Why ?
I have a custom dialog box in which users can specify a number of search parameters. The users simply input data into fields, and then I have LS code that takes the data and parses it to create a search string. That search string is applied as follows :
collection = database.FTSearch(searchstring,maxdocs)
The issue I have is that when the code executes, there are no documents returned by the search (the collection is empty - count = 0), whereas if I type the same search string into the Search box, a half-dozen docs DO show up.
An example of search is this :
FIELD Status="2" & FIELD Subject="execute"
In this case, if the status field is 2 and the Subject field contains the word "execute", the doc should be returned.
There are 7 docs that correspond to this criteria, as using this string in a manual search confirms.
When this same search string is applied to the FTSearch method, the collection turns up empty.
Why ?