>>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:290433 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
