[ic] One-click search with multiple tables

John1 list_subscriber at yahoo.co.uk
Mon May 31 17:01:01 EDT 2004


Please could someone suggest the best way to run a one-click search against
multiple joined database tables, not just against the products table.

Now I can do something like this by defining a search profile called brand:

www.mydomain.com/scan/se=sony/mp=brand.html

This works, but the problem is that I wish to *sort* these results by
product category, a field which is in an entirely different database table.
i.e.  If I could use SQL then I would simply write an SQL query which joined
the two tables, but how do a achieve this result from a hyperlink, i.e. a
one-click search.

As I would like search engines to follow the link, I also wish to avoid
passing cgi parameters e.g.
www.mydomain.com/scan/se=sony/mp=brand.html?param1=this&param2=that

I suspect I may be able to do this by creating an action map which takes me
to a page which then runs an SQL search using [query], but I am not sure &
have never used action maps.  Am I thinking along the right lines, or is
their a simpler or better way.

I would be very grateful for some pointers in the right direction.  Thanks.



More information about the interchange-users mailing list