lua-users home
lua-l archive

[Date Prev][Date Next][Thread Prev][Thread Next] [Date Index] [Thread Index]

Thanks a lot for your help. I am using sqlite3.

On Wed, Feb 3, 2010 at 9:11 AM, Florian Weimer <> wrote:
* noel frankinet:

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

Ahem.  This really depends a lot on the database and on the connection
state.  Blindly doubling ' does not work in all cases.

For instance, for PostgreSQL, LuaSQL offers a conn:escape(str) method
which is implemented by the PostgreSQL folks themselves and thus very
likely correct (but the older version wasn't for multi-byte encodings