Just prefixing something with a fixed query to 'hack' a wildcard query could lead to performance/memory issues.
I recommend indexing the file extension (or mime type) as a separate field.
Erik
On Wednesday, May 28, 2003, at 11:58 AM, David Warnock wrote:
Aviran,
You can also index the file names with a leading character. For instance
index "file1.exe" will be indexed as "_file1.exe" and always add the
leading character to the search term.
So if the user input is "*.exe" your query should be "_*.exe" and if the
user input "fi*" you'll change it to "_fi*"
Now that is a much neater solution than mine. Does this cause problems with unbalanced indexes or anything as all terms begin with the same character?
Dave -- David Warnock, Sundayta Ltd. http://www.sundayta.com iDocSys for Document Management. VisibleResults for Fundraising. Development and Hosting of Web Applications and Sites.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
