Re: Looping
- From: Mangood <marcin.sworzynski@xxxxxxxxx>
- Date: Wed, 21 Nov 2007 00:23:43 -0800 (PST)
On Nov 20, 1:51 pm, Jan Eliasen <elia...@xxxxxxxxxxxxx> wrote:
On Mon, 19 Nov 2007 13:00:34 -0800 (PST), Mangood
<marcin.sworzyn...@xxxxxxxxx> wrote:
Hi
I hava xml as following:
<ticket>
<person_name>
aaaaaaa
</person_name>
<route>
<dest>waw</dest>
<dest>orc</dest>
<dest>ale</dest>
</route>
</ticket>
In map need loop thru <dest> field elements and perform database
lookup at each of destination. Lookup should return information
whether destination is domestic or foreign. Based on this information
I should send one field element to output schema with proper account
number (it's constant string).
How can I achive that in biztalk ???
If I understand you correctly, you can use the DB Lookup functoid in a
map to look up the domestic/foreign values?
--
eliasen, representing himself and not the company he works for.
Private blog:http://blog.eliasen.dk
Private email: j...@xxxxxxxxxx
Yes I can use it. But how to code following algorithm using map:
loop thru all <dest> elements in <route> record
If any of those <dest> elements is foreign break the loop and produce
output <foreign accnt number>
otherwise
output <domestic accnt number>
so as input we have one or more <dest> elements and produced output
should be one element with accnt number.
I don't know if it's even possible :(.
Thanks for your help.
.
- References:
- Looping
- From: Mangood
- Re: Looping
- From: Jan Eliasen
- Looping
- Prev by Date: Re: BTS 2006 and SubmitDirect adapter running under Web Service
- Next by Date: Re: LeaseTime can only be set once within an AppDomain.
- Previous by thread: Re: Looping
- Next by thread: Re: AS2 Async MDN failing
- Index(es):
Relevant Pages
|