Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Boolean Searches on Multi-Selects

Quote Reply
Boolean Searches on Multi-Selects
One of our tables has a column called Country
Type: VARCHAR(255)
Form Type: MultiSelect
Form Names: code numbers
Form Values: actual country names

Search on one of these countries returns an accurate list -- but now we are wondering how to get a meaningful multi-select result, eg:

Using the default search_results now, separate searches on 'France' and on 'Canada' return intersecting lists.

What we really need is a multi-select search on France OR Canada
France AND Canada would be very helpful.
France NOT Canada would be great.

GT: is there a way to do this in our customized template?

Last edited by:

YoYoYoYo: Feb 13, 2003, 10:24 PM
Subject Author Views Date
Thread Boolean Searches on Multi-Selects YoYoYoYo 2984 Feb 13, 2003, 10:01 PM
Post Re: [YoYoYoYo] Boolean Searches on Multi-Selects
YoYoYoYo 2826 Feb 19, 2003, 7:57 AM