[ic] Brand Listing

[interchange-users@icdevgroup.org (Marty)]

On Mon, 2002-08-05 at 04:54, Ronald Camilleri wrote:
> Dear List,
> 
> I am working on a catalog running on interchange 4.8 and added a field
> (brand) in the products table. Everything is working as should. My client
> needs a list of the brands available in a particular area (selected).
> 
> First I make a search for the areas:
> 
>  [page brand]
>         <b>Search for available brand names in</b>
> 
>                   <select name=search1>
>                   [loop option=area search="
>                         fi=area
>                         sf=which_page
>                         se=all
>                         rf=code, name
>                         tf=name
>                         sp=brand
>                    "]
>         <option value = "[loop-data area name]" > [loop-data area name]
> </option>
>                   [/loop]
>                   </select>
>   areas.
> [/page]
> 
> 
> When the user select the area will be sent to the result page 'brand':
> 
> Brand Names found online for
> [cgi mv_searchspec]
> 
> <br>
>  [loop search="
>                     fi=products
>                     se=[cgi mv_searchspec]
>                     sf=prod_group
>                     rf=sku, brand
>                     un=1
>                     tf=brand
>                     ml=1000
>             "]
> <option value="[loop-data products brand]"> [loop-data products brand]
> </option>
>  <br>
>            [/loop]
> <br>
> <hr>
> <br>
>    <H3>Other Brand Names that we stock:</H3>
> <br>
> <table............
> 
> This code will list all brand names and not making the search with the
> selected area name, I tried many different combinations to convert
> mv_searchspec to a string from the information found online and in mailing
> lists but with no success. Also I cannot figure out how to display only one
> match when more than one brand of the same name is found.
> 
> Well done to all those who in some way or another helped in producing this
> product.
> 
> Ronald Camilleri
> 

Hi Ronald,

Try using [value-extended mv_searchspec].   If I recall, mv-searchspec
is stored in a hash reference so that's the only way (excluding using
embedded Perl) to get at it.

Other than that, your code looks like it should work ok.  Good luck

-- 
-  - -- ----  ----------------------------------------- --- -- -   -
Marty Tennison	 	The Sediva Company
email: marty@sediva.com
web: www.sediva.com
phone: +1-866-473-3482
fax: +1-775-256-4660
-  - -- ---- 
-------------------------------------------------------------- --- -- - 
-