The only advantage of using the underscore for table columns is that it
gives you a clue that the data is raw data from a table an not a formatted
variable.
eg. date_of_birth = {ts 2006-01-01 00:00:00} but dateOfBirth = "01/01/2006"
the one i find funny tho is where tables are prefixed with 'tbl' in the
database. Ive never really been confused if something was a view / sp or a
table so i just dont see a need for this kind of naming convention.
Pat
On 1/4/06, Hal Helms <[EMAIL PROTECTED]> wrote:
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]
----------------------------------------------------------
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]
