[Gambas-user] problem with "&" and mysql

[Andreas Fröhlke]

Charlie Reinl schrieb:
>>Hello,
>>
>>I have a problem with mysql and the charakter "&". I like to use a 
>>"INSERT"-statement with gambas like:
>>
>>INSERT INTO tabTest SET textfield='Hello & Bye' ;
>>
>>If I use this statement under phpmyadmin it will work, but with gambas 
>>it raises an error. Only without the "&"-Charakter it work.
>>Please Help
>>
>>Thanks, A.Fröhlke
>>
>>P.S. Sorry for my bad english, I'm from germany ;)
>>
> 
> Salut,
> 
> try it with && and think also that ' exists.
> 
> Amicalment
> Charlie
> * Gesendet mit / Sent by: FEN-Webmail * http://www.fen-net.de *
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=k&kid3432&bid#0486&dat1642
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user

Hi,

It don't work. My "new" SQL-statement was:

INSERT INTO tabTest SET textfield='Hello && Bye' ;

I also tried this:

INSERT INTO tabTest SET textfield='Hello \& Bye' ;

but it also don't work. Have anyone an idea?

Thanks A.Fröhlke