All Forums  Snitz Forums 2000 MOD-Group  MOD Add-On Forum (W/O Code)  boolean search expressions

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by philwhite[/i] [br]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. [i]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.[/i]< [/quote]   Check here to include your profile signature.