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

[Arie Hol]

On 9 Feb 2006 at 9:33, Andreas Fröhlke wrote:

8<------------ snip ----------->8

Instead of using :

	db.exec("INSERT INTO tabTest SET textfield='Hello \\& Bye' ;")

Try this :

	db.exec("INSERT INTO tabTest SET textfield='Hello \& Bye' ;")


In the top example you are escaping the \ and not the &

The system thinks you want to use \& as the desired characters.

To escape a character only use one \


Regards Arie
------------------------------------------------------------------
 For the concert of life, nobody has a program.
------------------------------------------------------------------