Hi biztalkgurus
I have an issue with database functoid. i am using a value extracter to extract the result. But the problem is if my database lookup returns more than one value. The extracter only pulling one value. I would like to explain further using the schemas.
my source schema looks like this
<request>
<header>
<desc>abc</desc>
</header>
<header>
<desc>def</desc>
</header>
</request>
My Database look up functoid which takes input orderno from the source schema
table POrders
column column
orderno desc
125 abc
125 def
in the lookup functoid takes orderno, connectionstring, POrders, orderno
now i have a table extracter which extracts for column (desc) and returns to the outputschema
My output schema after execution is
<response>
<header>
<desc>abc</desc>
</header>
</response>
but my desired output is
<response>
<header>
<desc>abc</desc>
</header>
<header>
<desc>def</desc>
</header>
</response>
Thanks for the response and very much appreciated
regards
ram