These were exactly the same comments I posted in the discussion section of Randy's wiki :)
OMG, I'm in complete agreement with Claude! The world must be ending... LOL! As for the UPPERCASE DB stuff - that came from the Oracle DBA team at Macromedia (so, yeah, it's a legacy Oracle guideline). On 10/5/07, Claude Schneegans <[EMAIL PROTECTED]> wrote: > >>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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290466 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
