11-02-2010, 01:08 PM
Thanks so much for your explanation. I just need filename/filepath. I don't need to index the actual filetext (pdf's).
To bind each word to the files, I geuss inwould have to put each filename first into it's own db lookup table so that I then would have to bind only the row number for the article in the main table (or else the list of full filenames for common words would be so huge if it was a fulltext entry for each bounded file.)
After that, it would be easy to match an OR statement (additive) but the much more useful and specific AND statements seems more complicated. Would I have to do a series of nested loops for each AND word in the search query?
Thanks for any thoughts, Stuart
To bind each word to the files, I geuss inwould have to put each filename first into it's own db lookup table so that I then would have to bind only the row number for the article in the main table (or else the list of full filenames for common words would be so huge if it was a fulltext entry for each bounded file.)
After that, it would be easy to match an OR statement (additive) but the much more useful and specific AND statements seems more complicated. Would I have to do a series of nested loops for each AND word in the search query?
Thanks for any thoughts, Stuart