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

Andreas Fröhlke afroehlke at ...784...
Thu Feb 9 12:51:05 CET 2006


nigel at ...38... schrieb:
> I can confirm that with gambas 1.9.24 and mysql 5 that 
> db.exec("Insert into tablename set fieldname = 'Hello && Goodbye') works for me.
> 
> Try setting DB.Debug = True prior to the statement to check what is actually being passed to
> mysql.
> 
> Regards
> 
> Nigel
> 
> 
> 
>>Message Received: Feb 09 2006, 09:25 AM
>>From: "Benoit Minisini" <gambas at ...1...>
>>To: gambas-user at lists.sourceforge.net
>>Cc: 
>>Subject: Re: [Gambas-user] problem with "&" and mysql
>>
>>On Thursday 09 February 2006 10:13, Andreas Fröhlke wrote:
>>
>>>the same error, without ";"
>>
>>Which database driver do you use?
>>
>>-- 
>>Benoit Minisini
>>
>>
>>
>>-------------------------------------------------------
>>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=lnk&kid3432&bid#0486&dat1642
>>_______________________________________________
>>Gambas-user mailing list
>>Gambas-user at lists.sourceforge.net
>>https://lists.sourceforge.net/lists/listinfo/gambas-user
>>
>>
> 
> 
> 
> 
> -------------------------------------------------------
> 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,

I set db.debug = true and here is the result:

I send:
INSERT INTO AfTest SET Text='Hello & Bye'

mysql receives:
mysql: 0x81b33b0: INSERT INTO AfTest SET Text='Hello INSERT INTO AfTest 
SET Text='Hello & Bye'

This is very strange. I'Dont have an Idea to solve this problem.




More information about the User mailing list