Re: Mysql Topic =?ISO-8859-1?Q?Can=B4t?= update when string has semicolon
Kai Peters (kpeters)
25-Jul-2008/16:10:41-4:00
#44155
<Back Thread Next>
<Back Index Next>
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
<Back Thread Next>
<Back Index Next>REBOL.com