array and revExecuteSQL

[axwald]

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