Live code and update a mysql table

Ludovic THEBAULT ludovic.thebault at
Sat Jun 25 07:51:44 EDT 2016


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 ?


More information about the Use-livecode mailing list