[ic] A batter way? - Menus, Prod Groups, Categories

Ed LaFrance edl at newmediaems.com
Fri Jan 9 11:49:24 EST 2004

At 10:56 PM 1/8/2004 -0500, you wrote:

>Short Version:
>Where might I find an example of creating a new page or new component
>where I can take a URL parameter and write my own SQL queries, and output
>Long Version:
>I'll make a list of how I'd like the workflow to go ...
>1) A store front index page with a left hand menu, containg only the
>store's product groups.  I can easily see how to do that with the menu
>2) When clicking on a left hand menu link, the url goes to a page where it
>takes the Product Group as a URL parameter and displays a list of
>categories in the center.
>   Q: How to access URL parameters in a component/page?

 From elements in the URL can be accessed with the [cgi] tag.

>   Q: How to develop custom SQL queries and output the data.

You would need to write a [query] with associated sub-tags on the target 
page to list your categories - see the Interchange tagref and the 
documentation for your particular flavor of SQL dbms for more info.

- Ed L.

>3) When clicking on the category link it goes to a page which lists the
>products, simmilar to the default search.
>I'm picturing this ot be a simple 3-tier link structurt from opening the
>storefront page with product groups, to categories, to the actual product?
>Does this sound reasonable?
>interchange-users mailing list
>interchange-users at icdevgroup.org

New Media E.M.S.              Technology Solutions for Business
11630 Fair Oaks Blvd., #250   eCommerce | Consulting | Hosting
Fair Oaks, CA  95628          edl at newmediaems.com
(916) 961-0446                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (916) 961-0447 Fax

More information about the interchange-users mailing list