Hi Stephen, Fortunately this db schema is not of my design and unfortunately i'm not able to change it.
Most applications have a User table, if those users are organized then there may be a Group table, and if theres any kind of ecommerce or whatever going on then it might have a Order table. How would you name these so as not to use reserved words? > Not sure why you would want to allow or continue to use badly formed sql. I don't consider SELECT `UserId` FROM `User` to be badly formed sql. when i'm writing sql i would enclose every table and column in back ticks whether thay are reserved words or not - because then they change color in my sql ide and that makes it look nice! :D I've used all those words above as table names in the past (now you hate me don't you ;-)) because they are accurate description of what they are. Just because the dbms says its a reserved word doesn't mean you should not use it - the dbms provides you with a way of escaping them for precisely this reason. If you use MySQL server you will know that the mysql db actually has a table called "user" I'm not spoiling for a fight, just curious for your opinion on this Cheers, Chris 2008/11/19 Stephen Moretti <[EMAIL PROTECTED]> > > > 2008/11/19 Mark Mandel <[EMAIL PROTECTED]> > >> >> Ah yeah.. that's not going to work. >> >> It is a limitation of Transfer. >> > > Probably quite a good limitation. > Not sure why you would want to allow or continue to use badly formed sql. > > To be honest, if you're building something new and have the access to > change the database schema, I would get it changed. > > Sorry grumpy pet-peeve of mine is using reserved words in database columns > or in general. Makes my blood boil..... > > Stephen > > > > --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to transfer-dev@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---