My sql execute snap

[rjapala]

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]

Thank you for reply @alchemiz

I tried with your suggestion but even throwing same error

[alchemiz]

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]

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

[darshthakkar]

Great news, something new we all learned today.
Incredible community!

CC: @dmiller

[darshthakkar]

That’s good news @rjapala, congratulations.
I’m still amused on why your previous query didn’t work, I will try it out on my end when I find a use case and share the findings here.