| T O P I C R E V I E W |
| philwhite |
Posted - 11 October 2005 : 06:10:50
I hope this is the right place for this! Please correct me if it is not.
I'm currently messing around with an advanced search function for the entire site I'm working on. It also searches the forum. Ultimately, I'll also look at changing the forum search form in a similar way and making it available if anyone's interested.
So far I've got a "simple search" which supports wildcards and quoted phrases and an advanced search which supports a restricted range of Boolean expressions and bracketing.
The current very rough version is up at http://www.wordwizard.com/demo/search
(BTW, the forum goes under the name "Clubhouse" on the site).
I have two issues:
1) Currently, the simple search function searches the sum of all the fields (topics and replies and subjects). Thus, searching for "aaa bbb ccc" with the standard search if the subject contains "aaa", the topic contains "bbb" and a reply contains "ccc" would return a hit. The advanced search currently searches only in discrete fields, and thus the search for "aaa AND bbb AND ccc" in the above example would not return a hit. Ultimately I want to provide something like a "discrete field" checkbox to allow both search modes for both the advanced and simple searches. It's no problen for the simple search, but generating the SQL for a search over the sum of all fields using a bracketed boolean expression is beyond me. Thus, my simple question. Is there any way, within the actual SQL statement, of concatenating the fields I want to search?
2) I'm using the highlighting function to highlight search terms in the forum results in the same way that the forum search does. Can anyone think of a way of applying this to wildcard expressions? The only way I can think of at present is to break down the search string and highlight every word in it, which would at least highlight the beginning and end of the phrase.
Ed. By the way, the site is only a demo, and it won't be going live for a while. If you wish to post, please do so from the main site.< |
| 1 L A T E S T R E P L I E S (Newest First) |
| HuwR |
Posted - 11 October 2005 : 09:22:34
you can't concatenate the topic/reply message because they are ntext fields< |
|
|
