Re: building categories using sql

[Erik Aase-Remedios <erik@fourfish.com>]

******    message to minivend-users from Erik Aase-Remedios <erik@fourfish.com>     ******

I believe that all you want to do is pass a query term to the next page?
build your link like this:
[sql type=list
      query="select distinct varietal from products order by varietal"
][page href="categories" arg="[sql-param varietal]"] [sql-param varietal]
[/page]
[/sql]
That will build a link to a page called categories and pass as an argument
the varietal.

Then on your categories page you do this:
[sql type="list"
  query="SELECT ..... Where varietal = [data session arg]"]
[sql-param code] [sql-param title] etc...
[/sql]

It's kinda like doing a specialized search page, but with SQL.

-Erik

>>>>> petong wrote (02:09 PM 3/14/99 ):
>******    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

-
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