Luís Santos wrote:
It is my opinion that parametrized queries can only be achieved when one has access to the database schema -- a thing that is currently outside LuaSQL scope.

i.e.: how can LuaSQL know that "123" should be treated as a number and not as a string (or date, or blob) if it has been passed to the API as a string?

For PostgreSQL and SQLite, this is a non-issue. The data is passed to the engine as strings and massaged into place. I've already written the code for PostgreSQL using tricks I've been using in production code for a few years. I'd have to check into OCI - and leave MySQL to someone that's interested in working on it. ;-)

 -P


_______________________________________________
Kepler-Project mailing list
Kepler-Project@lists.luaforge.net
http://lists.luaforge.net/cgi-bin/mailman/listinfo/kepler-project
http://www.keplerproject.org/

Reply via email to