[ic] Search within search on multiple tables

[John Beima]

G'Day Jason,

In your case you don't have to... You just need to learn Interchange a little 
more...

You see the pricing database uses the exact same sku number as the products 
database... Actually for every entry in the Products database you should have an 
entry in both ther pricing and inventory database.

This way when you are in your [search-region] with the products database, you 
can use the data tag with the exact same key of [item-code] to get your results 
out of the pricing or inventory databases...

John Beima


Quoting Jason Currell <currell@nettwerk.com>:

> 
> I'm wondering if anybody knows how to do multilevel searches.
> For example lets say I have a products table and a price table.
> How would I do a search on the description in the products table
> and use the results of that search to then search the product
> table (all in the same page).
> 
> Is there a way to embed <search-region> tags. eg:
> 
> [search-region prefix=prod search="
>         fi=products
>         st=db
>         ra=yes
> "]
> 
>    [search-list]
> 
>       [search-region prefix=price search="
>          fi=prices
>          st=db
>          sf=product_sku
>          se=[prod-data products sku]
>       "]
> 
>          [search-list]
> 
>             [price-code]<P>
> 
>         [/search-list]
> 
>      [/search-region]
> 
>    [/search-list]
> 
> [/search-region]
> 
> --------------------------------------------------------------------
> If not is there a way to put the results of one search 
> into a scratch-array of some sort for use later? eg).
> 
> [search-region prefix=prod search="
>         fi=products
>         st=db
>         ra=yes
> "]
> [search-list]
> [set the_products(index)][prod-code][/set]
> [/search-list]
> [/search-region]
> 
> 
> --------------------------------------------------------------------
> Jason Currell        | System Administrator for Nettwerk Productions
> currell@nettwerk.com | 1650 West 2nd Ave. 
> (604) 654-2929       | Vancouver, BC V6J 4R3
> 
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
> 



John Beima
jbeima@palb.com

P.A.L.B. Systems - Phone: (780)451-1086 - Fax: (780)447-4760
11639-122 Street, Edmonton, Alberta, Canada, T5M 0B6