Re: building categories using sql

[petong <petong@jah.net>]

******    message to minivend-users from petong <petong@jah.net>     ******



cfm@maine.com wrote:

> ******    message to minivend-users from cfm@maine.com     ******
>
> > ******    message to minivend-users from Peter Hicks <peter@wine-trader.com>     ******
> >
> > hello list,
> >
> > I am attempting to build a list of categories using the following
> > method:
> >
> > [sql type=list
> >       query="select distinct varietal from products order by varietal
> >    " ]
> > [sql-param varietal]
> > [/sql]
> >
> > What I would like to do is to make this a list of links that would
> > produce a page containing all items that belong in this category. Do I
> > have to pass the variable to the sql list on the next page to loop out
> > all the items? I seem to be at a loss on this one. Thanks for the help!
>
> build search page links
> [scan se=<stuff category into mv_searchspec here>] Text here [/page]
>
> Search docs for "scan".
>

This is actually the desired effect, but I would like to accomplish this without using scan.
The page build time is too long, so I would rather build the page directly from a second sql
query. Let's say that I build a list using the above query. If someone clicks on a varietal
such as 'merlot', I would like the next page to contain a query like so:

[sql type=list
      query="select code,title,year,varietal,vineyard, from products where varietal like
'[value varietal]' order by title
   " ]

[sql-param code] [sql-param title] etc...

[/sql]


Does this make any sense?



>
> >
> > -
> > To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> > email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> > Archive of past messages: http://www.minivend.com/minivend/minivend-list
> >
>
> --
>
> Christopher F. Miller, Publisher                            cfm@maine.com
> MaineStreet Communications, Inc        208 Portland Road, Gray, ME  04039
> 1.207.657.5078  (MTRF 3-5pm)                        http://www.maine.com/
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list