Claude, Ok I do agree that the Database section should be tailored to the database platform As you mentioned Oracle is one that does maintain case sensitivity.
I do agree that MySQL, MS-SQL, and even Access is case-insensitive. I recall a benchmark results from along time ago indicating that if your doing more than 3 CFIF/CFELSEIF statements it was better for performance to use CFSWITCH. That was discussed here on the mailing list of HoF. -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Saturday, October 06, 2007 12:34 AM To: CF-Talk Subject: Re: CF Coding Standards >>Precede all but simple variables with a prefix that indicates what type of data is in the variable. Yurk ! This is going back to FORTRAN where integer variables started with IJKLMN ! And it is particularly useless in a typeless language like CF. >>Use functions when doing TEXT comparisons in CFIF Why ? this is only making things look more complicated for nothing. >>Use CFSWITCH when you can as it runs faster than several CFIF/CFELSEIFs false. CFSWITCH is just equivalent to CFIF...CFELSEIF. It is just more readable when it replaces many CFELSEIF. You're using all upper case names for columns and tables. This only a bad habit inherited from Oracle. Most DB systems are case insensitive, and since table and column names become CF variable names, the best is yo use the same convention as for CF variable names. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290441 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
