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

Carlos Lorenz (carlos.lorenz)
25-Jul-2008/16:28:08-4:00
#44156
<Back   Thread   Next>
<Back   Index   Next>

Hi Kai,

I am afraid I do not know how to do it as I never used parameters before
with mysql-protocol

Would you mind giving me a clear example or point me some text to read on
the internet?

Thanks

2008/7/25 Kai Peters <kpeters-otaksoft.com>:

>
> On Fri, 25 Jul 2008 16:44:21 -0300, Carlos Lorenz wrote:
> > Hi list
> >
> > The query string below just won=B4t work because of the semicolon inside
> the=
>  string. Is there a
> > safe way of escaping this semicolon?
> >
> > Update mytable set myfield=3D"blabla;blabla"
> >
> > Anyone?
> >
> > --
> > Carlos Lorenz
> > www.revistaeletronica.com.br
> > Unidade Lorenz Ltda
> > (11) 4034 1971
>
> Hi Carlos ~
>
> just tried this with a parameterized query and it works fine;
>
> i.e. 'Update mytable set myfield=3D?' and pass in the value(s) separately
> as=
>  parameters.
>
> Cheers
> Kai
>
> --
> 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