MySQL problem...

[jbv]

Jean-Pierre,

have tou tried putting a backslash before the apostrophe :

revExecuteSQL IDdata,"insert into table1 values (5,'c\'est beau l\'amour')"

Jb


> hello,
>
> I have a some problem with MySQL ,
>
> this line work fine :
>
>      revExecuteSQL IDdata,"insert into table1 values (5,'new word')"
>
> but this one doesn't work , why ?
>
>      revExecuteSQL IDdata,"insert into table1 values (:1,:2)",5,"new
> word"
>
>   so i can't use "c'est beau l'amour" as new word because there is
> confusion between quote and apostrophe ...
>
>         revExecuteSQL IDdata,"insert into table1 values (5,'c'est beau
> l'amour')" Sig...
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences: