[REBOL] Re: Mysql Topic =?ISO-8859-1?Q?Can=B4t?= update when string has semicolon
From: carlos::lorenz::gmail::com at: 29-Jul-2008 13:44
Hi Tom,
Thanks for the help but using backslashes does not work for me.
2008/7/25 Tom <Tom.Conlin-gmail.com>
> Carlos Lorenz wrote:
> > Hi list
> >
> > The query string below just won=B4t work because of the semicolon insid
> e the
> > string. Is there a safe way of escaping this semicolon?
> >
> > Update mytable set myfield="blabla;blabla"
> >
> > Anyone?
> >
>
> have you tried
>
> myfield="blabla\;blabla"
>
> I backslash chars for other DBMSs and it works
> --
> To unsubscribe from the list, just send an email to
> lists at rebol.com with unsubscribe as the subject.
>
--
Carlos Lorenz
www.revistaeletronica.com.br
Unidade Lorenz Ltda
(11) 4034 1971