Remove the ticks around the one. Your placeholder needs to be :1, with the extra ticks you're turning it into a string. (I'm surprised that it even works)
On Sat, Jun 25, 2016 at 5:51 AM, Ludovic THEBAULT < [email protected]> wrote: > 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 > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
