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

[Joshua Jensen <jjensen@...>]

----- Original Message -----
From: Florian Weimer
Date: 2/3/2010 7:27 AM
> > Thanks a lot for your help. I am using sqlite3.
> >      
> Here's a complete example.  It turns out that LuaSQL doesn't support
> parametrized queries (or prepared statements), so you have to do your
> escaping manually.
>    
I've always found it bothersome that LuaSQL doesn't support prepared 
statements.  That has forced me to find alternatives.

Lua-Sqlite3 (http://luaforge.net/projects/lua-sqlite3/) supports 
prepared statements.  I've used it a bunch.  It works fantastically.

LuaDBI (http://code.google.com/p/luadbi/) also supports prepared 
statements and works with SQLite, MySQL, PostgreSQL and others.  I've 
used this a bit, and it seems to work pretty well.

Josh