Forum Discussion

rjapala's avatar
rjapala
New Contributor III
3 years ago

My sql execute snap

Am facing this error when am trying to update column data in SQL dynamically please can anyone give me a solution how to update with correct syntax using with expressions or without
rjapala's avatar
rjapala
New Contributor III
3 years ago

Thank you for suggestion @darshthakkar I have tried with different approach using Pipeline execute snap and i have kept the My sql execute snap in child pipeline it is working successfully now

Thanks for the support @ddellsperger @darshthakkar

alchemiz's avatar
alchemiz
Contributor III
3 years ago

Here’s an expression that I’ve been using to shorthand the string concatenation in generating an sql statement

"update my_table set my_field = '\$my_update_field', my_null_field = '\$my_null_field' where my_field = '\$my_condition_field'".replace(/\$\w+/gi, m=> eval(m) ).replace(/'null'/gi, 'null')

  • rjapala's avatar
    rjapala
    New Contributor III
    3 years ago

    Thank you for reply @alchemiz

    I tried with your suggestion but even throwing same error

    • alchemiz's avatar
      alchemiz
      Contributor III
      3 years ago

      Your missing the replace function

      "UPDATE rakesh_sf_customer_order SET Error_reason = '\$Error_reason' WHERE Customer_ID = '\$Customer_ID'".replace(/\$\w+/gi, m=> eval(m) ).replace(/‘null’/gi, ‘null’)

      The closing ";" is what causing the batch operation failed

      • rjapala's avatar
        rjapala
        New Contributor III
        3 years ago

        Thank you so much @alchemiz

        I removed semicolon ; in the my sql execute snap then the query is working fine now.

        @darshthakkar Thank you for the support, Now query is working fine