One of the habits I got into is naming database columns according to their
data type. i.e. Memo, bit, numeric, date. etc...
ex:
Text: TXT_Fname
Text: TXT_Lname
Memo: MEM_Comments
Bit/Option: BIT_Active
Date: DATE_DOB
Currancy: CUR_Price
Look-up table: LKP_State
ID: ID_TableName
This is a sure fire way to know what data type a field is and what table the
ID is referencing. Thus, it is self documenting code and saves time when you
revisit code or some one has to work with your code, not to mention time
saved with debugging.
It also allows you to write scripts to generate code and queries and save
huge amounts of time
when dealing with tables with a large amount of fields
Coz
Cozmo
<HoloGraphic>INC.</HoloGraphic>
103 Meridian Street
Tallahassee, Florida 32301
______www.holographic.com_______
----- Original Message -----
From: "Eben Hewitt" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Tuesday, October 10, 2000 7:57 AM
Subject: Best Practices
> I am working on drumming up a list of best practices for CF coding. I
would
> welcome all of your personal Best Practices, and will publish it (and give
> contributors appropriate credit!) in the avenues I am able to (web, a
> journal, a txt file taped to my shaving mirror).
>
> I know that Ben Forta has a 10 Commandments, but I am thinking of more
> specific guidelines, such as 'Validate at the TOP of your form so you can
> immediately tell which fields contain a validation rule', and like that.
>
> I have searched the forums already for such a thing, and do not see it
> (myopia?). What are the little things you always make sure to do when
> coding?
>
> Thanks!
> Eben
>
>
> --------------------------------------------------------------------------
----
> To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
