If I understand this correct, you are looking for a "refine your search within the search results" concept here. A somewhat similar example of this can be found at Dice.com, the search phrases are stacked up for futher refining (eg. Keyword and ZipCode - you can UNDO a phrase for more generic results).
This can be implemented in many ways, of which one approach is to capture the search phrases in a session as a LIST and use the list in the SQL statements WHERE / AND clause. 1. the first time the user keys in "FAN", getting a 1000 record count. Your session contains "FAN" resulting in SQL like this ... WHERE columnSearch LIKE '%FAN%' 2. to refine it further the user keys in "INDUSTRIAL", now the session will have "FAN,INDUSTRIAL" resulting in SQL like ... WHERE columnSearch LIKE '%FAN%%INDUSTIRAL%' 3. and for more narrower refining, the user keys in "GREEN", now the session will have "FAN,INDUSTRIAL,GREEN" resulting in SQL like WHERE columnSearch LIKE '%FAN%%INDUSTIRAL%%GREEN%' ... can go on .... Note: you also need to provide an ability to modify the search results for better user experience. Hope this helps. Thanks, Ketan Jetty ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5100 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
