none
DBLookup Funtoid Issue in Biztalk Map RRS feed

  • Question

  • Hello,

    I have to pass the element 2 to input[0] of DB lookup functoid. Before pass the element2, I have to check the below condition. 

    Condition:

    if element1 =8 then pass element2..to DBlookup input[0] ,

    I tried with equal and value mapping functoid, I am getting the empty output

    if  I pass the element2 as input[0] to dblookup... without checking the condition its working fine.

    can't we use scripting or any logical functoid as a input[0] to dblookup?

    please guide me on this.


    Thanks, Archana

    Thursday, June 20, 2013 8:10 AM

Answers

  • Hi,

    I tried with Scripting functoid..now I am getting the output.

    sample code:

    **********

    public string CLOC(int CLQUAL,String CLID)
    {
        if(CLQUAL==8)
        return CLID;
       else
       return "Null";
    }


    Thanks, Archana

    • Marked as answer by Pengzhen Song Wednesday, June 26, 2013 10:14 AM
    Thursday, June 20, 2013 1:15 PM

All replies

  • Hi,

    I tried with Scripting functoid..now I am getting the output.

    sample code:

    **********

    public string CLOC(int CLQUAL,String CLID)
    {
        if(CLQUAL==8)
        return CLID;
       else
       return "Null";
    }


    Thanks, Archana

    • Marked as answer by Pengzhen Song Wednesday, June 26, 2013 10:14 AM
    Thursday, June 20, 2013 1:15 PM
  • Hi,

    We are happy that your issue has been resolved. And thanks for sharing solution with us.

    Monday, June 24, 2013 9:23 AM