[ic] One-click search with multiple tables
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:
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
As I would like search engines to follow the link, I also wish to avoid
passing cgi parameters e.g.
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