Replacing placeholders with variables on revdb_execute

Giulio Mastrosanti giulio at cantoberon.it
Wed Mar 20 07:22:01 EST 2002


Hi,
I'm trying my first insert on a MySQL database

I have a table named pwd with two columns,idconnessione is my connection id,
but if I try something like:

put "aa" into a
put "bb" into b
put "insert into pwd values(:1,:2)" into q
put revdb_execute(idconnessione,q,a,b) into risultato

I have an error, because I've seen the string sent to MySQL contains
"insert into pwd values(:1,:2)", no substitution of :1 with a and :2 with b
as expected.

Am I missing something?

Grazie,

    Giulio




More information about the use-livecode mailing list