You can create tables/columns with mixed case in modern versions of Oracle. The values stored within those columns is what is case sensitive so SELECT MyValue FROM MyTable WHERE theValue = 'abc' would return something different than SELECT MyValue FROM MyTable WHERE theValue = 'aBc' I personally do not care to use mixed casing on my table/column names but can be done, just tested it out to make sure.
On 10/6/07, ColdFusion <[EMAIL PROTECTED]> wrote: > > 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. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
