Viewing 13 posts - 1 through 13 (of 13 total)
Finally after all troubles I got it work! The search is pretty good, I know that my query is probably violating all the rules, but unfortunately, I cannot influence the...
June 2, 2006 at 12:35 pm
So when I though that I am finally getting all the SQL right, I ran into another problem. I am trying to search for author OR title, while using...
May 31, 2006 at 4:01 pm
That seems fairly easy, I will give it a try. I guess there si no easy solution for using NOT SOME_OPERATION containstable(title, ...). And for ordering, if I am correct,...
May 31, 2006 at 11:59 am
I solved the rank counting problem, I have used the COALESCE() function for assigning a value to a field in case that it is null. so the line which was...
May 31, 2006 at 11:17 am
That works perfectly. However, for the ordering by rank, I have created a new column called Rank = RankAuthor + RankTitle and then it works even better. Ok, so for...
May 31, 2006 at 10:48 am
One more question and hopefully final. I have multiple search fields with different options(keyword, author, title, ...) and for each of them I finally have a query which works pretty...
May 30, 2006 at 4:34 pm
At the end, I intended to use the FREETEXTTABLE or CONTAINSTABLE, I was just trying to get the multiple column search running with FREETEXT. But what you have just posted...
May 30, 2006 at 1:10 pm
Oh, I forgot about that. Those name are very weird I know, unfortunately I the database system was already created before I came here and I just have to create...
May 30, 2006 at 12:25 pm
That seems to work. Thanks a lot for your help. However, I need the results to be displayed according to rank, and when I use multiple or statements, it does...
May 30, 2006 at 11:59 am
Another problem(this time hopefully easier) which I am trying to deal with right now...How do you do a fulltext search on multiple(specified) columns? For example, FREETEXT(column1+column2, 'search_string'). How do you...
May 30, 2006 at 10:39 am
is there a way how I could join at first all the columns in one row into one long string, then perform the search on it and then return the...
May 30, 2006 at 7:59 am
#Quote
Or, run one or more queries as derived tables - providing the most general results using the partial matching - which is then further filtered using the main query.
#Quote
How could...
May 30, 2006 at 7:00 am
and how would you implement that? would you search for all the combinations of the words?
May 30, 2006 at 5:26 am
Viewing 13 posts - 1 through 13 (of 13 total)