Live code and update a mysql table

Mike Bonner bonnmike at gmail.com
Sat Jun 25 08:19:57 EDT 2016


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 <
ludovic.thebault at laposte.net> 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
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode



More information about the use-livecode mailing list