Live code and update a mysql table

Ludovic THEBAULT ludovic.thebault at laposte.net
Sat Jun 25 13:51:44 CEST 2016


Hello,

I want to update a column in a mysql table.

here my script :
put "UPDATE mytable SET myText = ':1' WHERE id =:2 » into tSQL
put fld "myText" into theText
put 2 into t_id
revExecuteSQL gConnectionID, tSQL, « theText", « t_id"

Even if theText = "Tralala", i got only ":1"  in my table in the column "myText" for the id 2

What i missed ?

Thanks


More information about the use-livecode mailing list