Re: Mysql Topic =?ISO-8859-1?Q?Can=B4t?= update when string has semicolon

Carlos Lorenz (carlos.lorenz)
29-Jul-2008/12:45:11-4:00
#44165
<Back   Thread   Next>
<Back   Index   Next>

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
> >=20
> > 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?
> >=20
> > Update mytable set myfield=3D"blabla;blabla"
> >=20
> > Anyone?
> >=20
>
> have you tried
>
> myfield=3D"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

REBOL.com