[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] Join search in 4.8.3 & mv_search_groups
My $.02
Just use sql --- send a form to one of the .html pages -- then put your
query on the html page and fill in the blanks with what you submitted in
the form.
Steve Graham wrote:
> Hello,
>
> I'm trying to do something like a Join or merge search like in SQL
> (psuedo code)
> select * from products,pricing join on sku where
> pricing.price_group=test and products.category=big
>
> It seems that I should be able to use something like, but I don't have
> a good grasp of the sequence of setting variables.
>
>
> [loop search="
> co=yes
> fi=pricing
> sf=price_group
> se=test
> sg=0
>
> fi=products
> sf=category
> se=big
> sg=1
> sr=0 AND 1
> tf=description
> "]
>
>
> Thanks,
> Steve
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
>
> .
>
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users