Re: when I insert table, value is a string contains apostrophe - it throws an error there - how to fix

[Vasanta <vtanna1@...>]

The whole string comes from Kernel as syslog, it saves into table, like that somany strings in Kernel code. Do I have to edit all those files whereever strings are, incase if new kernel gets releases later, is there anyway I can do in this INSERT string?.  Thanks in advance. I am new to this SQL.

 

 

On Wed, Feb 3, 2010 at 9:04 AM, noel frankinet <noel.frankinet@skynet.be> wrote:

Vasanta a écrit :

you must double the inside quote quote in sql  : 'MFD''s web managment'

Noel

But query value string contains, like below, I got error:

query  INSERT INTO eventLog ('component', 'facilityId', 'logLevel', 'textMessage', 'binMessage') VALUES ('UMI_COMP_PLATFORM', '3', '8', 'Tue Feb  2 21:18:52 2010 [Net MFD][System][PLATFORM] Reading Net MFD's web management interface 1', '')

errstr: LuaSQL: unrecognized token: "', '')"

******** table insert failed for eventLog

On Wed, Feb 3, 2010 at 8:09 AM, Florian Weimer <fw@deneb.enyo.de <mailto:fw@deneb.enyo.de>> wrote:

   * Vasanta:

   > *When I do INSERT like below, value is a string with apastrophe
   (for ex:
   > "Checking for 'hlt' instruction"), insert throws an error - how
   to fix?*

   Most SQL database access layers contain functionality which allows you
   to separate data from the query.  You should simply use that, and
   these problems go away.