Forums
This topic is locked
'AND' 'OR' searches from single text box?
12 Apr 2003 18:47:21 L G posted:
I've been able to add a simple search text box to my site which allows users to search an access database for a keyword. I now want to be able to let users type in a search, using a single text box, that lets them search for more than one keyword using and/or between words if they wish. eg entering 'keyword1 and keyword2' would return all records that contain both OR entering 'keyword1 or keyword2' returns all records that contains either. I would also like to let users search two different fields in my database in this way eg 'keyword and area' returns all records that have that keyword and are in a particular area. Keywords and areas are seperate fields in my database. I'm using DWMX with ASP VBScript. Whats the best and easiest way to achieve this? Is there a free extension or simple script that will let me do this? have tried 'simple search' extension but I think it only lets me enter one word to search for.