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

Mysql Topic =?ISO-8859-1?Q?Can=B4t?= update when string has semicolon

 [1/7] from: carlos::lorenz::gmail::com at: 25-Jul-2008 16:44


Hi list The query string below just won´t 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

 [2/7] 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
<<quoted lines omitted: 6>>
> 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

 [3/7] from: carlos:lorenz::gmail 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
<<quoted lines omitted: 23>>
> 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

 [4/7] from: kpeters::otaksoft::com at: 25-Jul-2008 14:04


On Fri, 25 Jul 2008 17:27:46 -0300, Carlos Lorenz wrote:
> 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
Carlos ~ look at: 6.2. Send an SQL query inserting REBOL's values here: http://softinnov.org/rebol/mysql-usage.html That should get you going. Kai

 [5/7] 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

 [6/7] from: carlos:lorenz::gmail at: 29-Jul-2008 13:43


Kai, The use of parameters solved the problem I had while updating my DB with mysql-protocol. Many thanks for the help! 2008/7/25 Kai Peters <kpeters-otaksoft.com>
> On Fri, 25 Jul 2008 17:27:46 -0300, Carlos Lorenz wrote: > > Hi Kai,
<<quoted lines omitted: 17>>
> 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

 [7/7] from: carlos::lorenz::gmail::com at: 29-Jul-2008 13:44


Hi Tom, Thanks for the help but using backslashes does not work for me. 2008/7/25 Tom <Tom.Conlin-gmail.com>
> Carlos Lorenz wrote: > > Hi list
<<quoted lines omitted: 13>>
> 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

Notes
  • Quoted lines have been omitted from some messages.
    View the message alone to see the lines that have been omitted