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: Petite Abeille
Date: 2/3/2010 11:13 AM
> On Feb 3, 2010, at 4:36 PM, Joshua Jensen wrote
> > I've always found it bothersome that LuaSQL doesn't support prepared statements.  That has forced me to find alternatives.
> >      
> True, but even without proper prepared statements support, you can get by with LuaSQL binding for 'escape':
>
> Each argument is transparently escaped using the appropriate 'escape' function provided by the connection:
>    
Sure, but I deal in lots of binary data.  While I don't understand the 
network protocols of the databases I use, there is a much better chance 
my binary data bound to the prepared statement is going to be handled in 
a much more optimal way than escaping the binary and compiling/sending 
it that way.

Plus, with prepared statements, you don't have to deal with escaping 
anything.  It's a double win... ease of use and performance.

Josh