Hi. Paul Dupuis via use-livecode wrote > I believe you need to surround the placeholder with single quotes.
Doesn't work, my LC doesn't do the replacement: > UPDATE `t_test` SET `Text` = ':11' WHERE `Nummer` = ':22'; and > UPDATE `t_test` SET `Text` = :'11' WHERE `Nummer` = :'22'; are sent to the db w/o changes. Interesting: > put "cText" into myArr[8] > put "99" into myArr[9] > put "UPDATE `t_test` SET `Text` = :8 WHERE `Nummer` = :9;" into StrSQL doesn't replace, whereas: > put "cText" into myArr[8] > put "99" into myArr[9] > put "UPDATE `t_test` SET `Text` = :1 WHERE `Nummer` = :2;" into StrSQL does - according to the order of the numbers ;-) So the placeholders in the SQL string MUST BE :1 to :9, and MUST BE used in ascending order. :0 isn't recognized. Paul Dupuis via use-livecode wrote > Also you can lose the semicolon as LC will only execute one statement at a > time. You cannot string statements. Well, it doesn't hurt either, and I'm so used to it :) Have fun! ----- • Livecode programming until the cat hits the fan • -- Sent from: http://runtime-revolution.278305.n4.nabble.com/Revolution-User-f278306.html _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
