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

[nigel at ...38...]

Appologies there should have been a closing quote:
db.exec("insert into tablename set fieldname = 'Hello && Goodbye'")

> Message Received: Feb 09 2006, 10:21 AM
> From: nigel at ...38...
> To: gambas-user at lists.sourceforge.net
> Cc: 
> Subject: Re: [Gambas-user] problem with "&" and mysql
> 
> 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=lnk&kid3432&bid#0486&dat1642
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
> 
>