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

[Vasanta <vtanna1@...>]

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