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

Comments

2 comments

  • 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

    delete_sql.png

     

    0
    Comment actions Permalink
  • Avatar
    felix.stuyck

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

    Thank you for the help!

    0
    Comment actions Permalink

Please sign in to leave a comment.