[ic] Join search in 4.8.3 & mv_search_groups

[Steve Graham]

I read one of the other emails, and someone suggested it might be better to 
use the [query] instead of [loop search..]
since you have better control over what is actually fetched from the sql 
server.

Unless someone else has any comments - maybe we should make a new thread
[query] vs [looop search]?

-Steve


>From: Michelle Wilant <michelle@wilant.com>
>Reply-To: interchange-users@interchange.redhat.com
>To: interchange-users@interchange.redhat.com
>Subject: Re: [ic] Join search in 4.8.3 & mv_search_groups
>Date: Fri, 07 Dec 2001 23:55:22 -0600
>
>Not totally clear on what you are asking, but I think you are just
>asking how to abuse that query in IC.
>
>[query  ...all that other stuff...]
>
>if your type = list then use
>[list]
>    [sql-param title] -- or whatever
>[/list]
>[/query]
>
>
>Someone correct me if I'm wrong in saying that I think you can
>substitute loop for list and it would work the same way.
>
>Michelle
>
>Steve Graham wrote:
>
>>I found that this SQL Query does what I need, but how do I write this
>>doing a loop search.
>>
>>query sql="select * from products,pricing where products.sku =
>>pricing.sku AND pricing.price_group='test' ORDER BY products.description"
>>         type=list
>>         more=1
>>           ml=10]
>>
>>Thanks
>>
>>
>>>From: "Steve Graham" <dtlgc@hotmail.com>
>>>Reply-To: interchange-users@interchange.redhat.com
>>>To: interchange-users@interchange.redhat.com
>>>Subject: [ic] Join search in 4.8.3 & mv_search_groups
>>>Date: Sat, 08 Dec 2001 03:42:18
>>>
>>>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
>>
>>
>>
>>_________________________________________________________________
>>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


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp