Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

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

From: carlos:lorenz:g:mail 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