I need some guidance for rebuilding a site search. It's a Coldfusion 5 (develpment server is MX) and MySQL site primarily. Right now I use Atomz search on the site and it works great. However, my client wants to do some funky things with the search that Atomz doesn't support unless you go to their enterprise solution ($15k+). So, that said if I am to pull this off I will probably just need to roll my own.
The site: mixed dynamic and static content. Most of the dynamic content is a product catalog. I need the whole site to be searchable and I need one search to do both static and dynamic content, which the Atomz search does great right now. Is there any way to do this if I don't have access to the Administrator through my web host?
The special feature: for a limited number of search strings (10-12 right now) my client would like the user directed automatically to a specific page. So if someone typed "blue marbles" they'd be directed automatically to the blue marbles product page for example (pages to be specified by him and programatically setup by me and cross-linked with search criteria).
Any ideas here? I thought I'd get some opinions before I run off down the wrong path and waste a bunch of time as I already have employing the Atomz search in the first place (which has always served me well by the way). Any help is appreciated.