Error executing script

waiyin.lee · June 20, 2019, 4:07am

I try run an update the database value.
The script is below

However facing the error executing script like below

waiyin.lee · June 20, 2019, 5:09am

Anybody able to assist for this debugging?

chi · June 20, 2019, 7:58am

Replace runUpdateQuery with runPrepUpdate. The rest of your script looks good to me.