02-17-2023 03:42 AM
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
02-20-2023 09:57 PM
02-21-2023 07:38 AM
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
02-21-2023 08:53 AM
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
02-21-2023 09:06 AM
Great news, something new we all learned today.
Incredible community!
CC: @dmiller
02-20-2023 08:40 PM
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.