On Sat, Apr 23, 2011 at 05:52:07PM -0600, Pгoм???тн?????s 0x01 wrote:
> Not sure if this is a bug or not, but it seems like I cannot create tables
> that have variables (columns) named after SQL keywords; could/should they be
> escaped in some way, or is this a limitation of SQLObject?
Not a bug, rather a deficiency - SQLObject doesn't quote column
names. You can try to create a patch, at least for MySQL, but pleas
don't make entire SQLObject MySQL-oriented; i.e. you should quote
column names only if the current DB is MySQL.
Oleg.
--
Oleg Broytman http://phdru.name/ ph...@ph...
Programmers don't die, they just GOSUB without RETURN.
|