Patrick Branley wrote:
> 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
I use underscores for columns in a table while my applications don't. I
find the seperation to be good - however, I use Mach-II with Value
Objection/Beans/TOs or whatever you wish to call them so I tend not to
use cfqueries often (unless it's comes from a Gateway object).
.Peter
--
Peter J. Farrell :: Maestro Publishing
http://blog.maestropublishing.com
Rooibos Generator - Version 2.1
Create boilerplate beans and transfer objects for ColdFusion!
http://rooibos.maestropublishing.com/
- Member Team Mach-II
- Member Team Fusion
----------------------------------------------------------
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]
