DataBase LookUp functoid issue

Home Page Forums BizTalk 2004 – BizTalk 2010 DataBase LookUp functoid issue

Viewing 1 reply thread
  • Author
    Posts
    • #18189

      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

    • #18212

      Database functoid will return the record set for a given row id. Using Table Extractors, you can get a specific column value for any column. For example, if you have 100 columns in the table and want to get the values for 10 columns, you will have to use 10 table extractor functoids. If you are planning to retrieve multiple rows in one DB lookup functoid, I don't think there is a way to do it. Anyway, there are some known issues with DB loopup functoid. It will not work properly if you use it for the situation where you are sending a bunch of messages at a time from the map. You better write your own script for this purpose.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.