Database lookup.

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Database lookup.

Viewing 1 reply thread
  • Author
    Posts
    • March 12, 2008 at 1:49 PM #19057
      community-content

        Hi,
        when using a database lookup functiod, if the results have multiple rows is there away of selecting one particular row or does it always select the first one? or is there a way of adding two critera’s e.g. if id = 1 and price = 0.99.

        Thanks.

         

      • March 18, 2008 at 12:40 AM #19080
        community-content

           

          Maximum number of input/output parameters for Database
          Lookup functoid are four so you can use more than one criteria’s.

          Keep in mind that the recordset returns only the first row
          of
          data that matches the specific criteria provided to the Database Lookup functoid.

          MAX

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