We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

JDBC execute - use input in SQL querry



  • Avatar
    Gerry Mullin

    You don't need to use the 'Use DbName' in the node. You should have that specified in your connection details. Then to reference your fields on the input pin you specify them in the SqlQueryFieldBindings and reference them (in order) with a ?.

    In screenshot example attached, I have a table called people with first and last names in it, I want to delete the rows that match the field LastName on my input.


    The help documentation explains it well also.



    Attached files



    Comment actions Permalink
  • Avatar

    The ? worked!
    Indeed the DBname in the code was redundant and specified in the connection details.

    Thank you for the help!

    Comment actions Permalink

Please sign in to leave a comment.