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

From: Tom::Conlin::gmail::com at: 25-Jul-2008 12:59

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?
>

have you tried

myfield="blabla\;blabla"

I backslash chars for other DBMSs and it works

1 · 2 · 3 · 4 · [5] · 6 · 7 · See whole thread