Thanks for the responses. Right now our company naming standards for DBs use all lower case and underscores ( we have had meetings and that is what was decided upon ). So I think for now, I am going to go with Aliasing the coulmsn to be mixed case so that it is consistent with the Bean and other objects.
Thanks for the help. -ben ...................... Ben Nadel Web Developer Nylon Technology 350 7th Ave. Suite 1005 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax www.nylontechnology.com Sanders: Lightspeed too slow? Helmet: Yes we'll have to go right to ludacris speed. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sean Corfield Sent: Tuesday, January 03, 2006 10:45 PM To: [email protected] Subject: Re: [CFCDev] Naming consistency On 1/3/06, Ben Nadel <[EMAIL PROTECTED]> wrote: > 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? That would get my vote. One of the benefits of having the gateway objects is that you can alias columns (and whatever other transforms you want) and present a consistent view of the data - even if the schema changes, you can often just modify the gateway object's SQL so that the rest of the application doesn't need to change (except where you need to add code to handle specific new columns perhaps). -- Sean A Corfield -- http://corfield.org/ Got frameworks? "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ---------------------------------------------------------- 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]
