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

[Vasanta <vtanna1@...>]

I cannot find LuaDBI in my original file, looklike not using, I found these in the beginning of the file:

 

--************* Requires *************

require "luasql.sqlite3"

--************* Initial Code *************

--package db

db = {}

--create environment object

local _DB_env = luasql.sqlite3()

local _DB_con = nil

--************* Functions *************

--Connect to the given DB.

function db.connect (dbname)

_DB_con = _DB_env:connect(dbname)

end

On Wed, Feb 3, 2010 at 10:06 AM, Ted Unangst <ted.unangst@gmail.com> wrote:

On Wed, Feb 3, 2010 at 9:54 AM, Florian Weimer <fw@deneb.enyo.de> wrote:
> LuaSQL should really, really support parametrized queries, though, but
> currently, it doesn't. 8-(

There's also LuaDBI, which does support them.  Not much documentation,
but easy to figure out.