[REBOL] Re: Mysql Topic =?ISO-8859-1?Q?Can=B4t?= update when string has semicolon
From: carlos:lorenz:gm:ail at: 25-Jul-2008 17:27
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="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=?' 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
