Le 31/03/2013 19:17, Charlie Reinl a écrit :
> Am Sonntag, den 31.03.2013, 09:47 -0700 schrieb abbat81:
>> I'm sorry, but I don't understand.
>>
>> <http://gambas.8142.n7.nabble.com/file/n41538/2013-03-31-194503_1680x1050_scrot.png>
>>
>> I have problem with quotes.
>
> Hallo,
>
> yes
> Qry="<table width='650'></table>"
>
> set to "UPDATE users SET login = '" & Qry & "'"
> gives you "UPDATE users SET login = '<table width='650'></table>'"
>
> behind the = you have '<table width=' and '></table>' and a 650 in the
> middle.
>
> try
> DConnect.$Con.Exec("UPDATE users SET login = &1",Qry)
> or
> DConnect.$Con.Exec("UPDATE users SET login = '" & replace(Qry,"'","''")
> & "'")
>
You should use the Gambas quoting facilities instead:
DConnect.$Con.Exec("UPDATE users SET login = &1", Qry)
Easier, isn't it?
--
Benoît Minisini
------------------------------------------------------------------------------
Own the Future-Intel(R) Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest. Compete
for recognition, cash, and the chance to get your game on Steam.
$5K grand prize plus 10 genre and skill prizes. Submit your demo
by 6/6/13. http://altfarm.mediaplex.com/ad/ck/12124-176961-30367-2
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
