Live code and update a mysql table

[Ludovic THEBAULT]

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