[REBOL] Re: Mysql Topic =?ISO-8859-1?Q?Can=B4t?= update when string has semicolon
From: kpeters:otaksoft at: 25-Jul-2008 13:10
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