I settled on a singular naming convention a long time ago and i'm probably too stubborn to change that, but i will keep this in mind if i get the chance to use transfer on any new projects.
Changing User to Users i can probably deal with that but Category to Categories aww man that would drive me nuts, its worse that 4 spaces rather than a tab! I am ever so slightly OCD when it comes to these sort of issues, and its getting worse with age! Cheers, Chris 2008/11/20 Alan Livie <[EMAIL PROTECTED]> > I prefer Users, Groups, Orders as my db tables .... avoids the reserved > words problem .... I have an Order class and object though but my db tables > are plural. > > I'm with Stephen on this. Reserved words as table and column names annoy me > too > > Alan > > > > ------------------------------ > *From:* Chris Blackwell <[EMAIL PROTECTED]> > *To:* [email protected] > *Sent:* Wednesday, November 19, 2008 11:09:20 PM > *Subject:* [transfer-dev] Re: Escaping reserved column names > > 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 [email protected] 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 -~----------~----~----~----~------~----~------~--~---
