Ben, I've joked for years that database designers go to Langley, VA (headquarters of the CIA) to learn how to name columns: that's the only explanation I can come up with for some of the bizarre names we see. But I often alias these in my SQL calls, as I feel it's important that the names be as clear as possible. As for your naming conventions, the get/set model is a very common one. In Java, the convention is to use getX and setX while the .NET world uses GetX and SetX. The difference is that .NET encourages uppercasing when the method is public.
Hal -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ben Nadel Sent: Tuesday, January 03, 2006 9:07 AM To: [email protected] Subject: [CFCDev] Naming consistency So, I have some issues with the way things get named. Right now, when I create beans and entity objects, the propery names are get/set via mixed case methods (ex. GetUserName(), SetAge()). However, when I get a query via a Gateway, the return properties (ie. column names) are all lower case with underscores (ex. address_1, daytime_phone). Now it just seems weird to me that these two interfaces for similar sets of data would have different naming styles. So the question is two fold: 1. Are my naming conventions just way off (looking for opinion here, not fact I know). 2. Would it seem crazy to, in my SQL, rename the fields (ex. SELECT daytime_phone AS DayTimePhone FROM foo) so that the interfaces were more consistent? Thanks, Ben ...................... Ben Nadel Web Developer Nylon Technology 6 West 14th Street New York, NY 10011 212.691.1134 212.691.3477 fax www.nylontechnology.com Sanders: Lightspeed too slow? Helmet: Yes we'll have to go right to ludacris speed. ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
