Hi Daniel,

I understand your point, however (someone correct me if I am wrong) I thought that the table and column names can be any properly escaped alphanumeric string in any DBMS that conforms to standards. In MySQL, I could name columns using `<colname>` to escape the name, and avoid problems with keyword names.

So I am still wondering if this can be done within SQLObject (or if it already is, and I am doing something wrong), or if there are any plans to do so in the future?

Thanks again

On Sat, Apr 23, 2011 at 11:40 PM, Daniel Fetchinson <fetchinson@googlemail.com> 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?

Why would you want to do such a thing? Is your backend allows for it?
If not, sqlobject is right to complain, if yes, but some other
supported backend does not allow for it then sqlobject is also right
to complain because you might want to switch in the future so is
protecting you.


Psss, psss, put it down! - http://www.cafepress.com/putitdown

Fulfilling the Lean Software Promise
Lean software platforms are now widely adopted and the benefits have been
demonstrated beyond question. Learn why your peers are replacing JEE
containers with lightweight application servers - and what you can gain
from the move. http://p.sf.net/sfu/vmware-sfemails
sqlobject-discuss mailing list