Yes, thats what I am trying to do. Again, I know nothing about Ajax, but I would rather use it because I didn't want the page refreshing everytime a user narrowed the search results down. I was hoping for some sample code, or a specific tutorial that would help me write the code. Thanks for all the help so far.
> 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:5105 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
