We have several data sources such as Active Directory, home-built databases and purchased databases. Each of these data sources may have different conventions for similar data elements. For example, Active Directory uses "givenName" and "sn". Our main business system uses "FIRST_NAME" and "LAST_NAME". While another database may use "FirstName" and "LastName" or "firstName" and "lastName". Knowing that you can't change the schemas for many common data sources, do you make any attempt to use consistent variable names in your CFM pages? In other words, do you alias all of your data elements so that your CF code only uses one naming convention? m!ke.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299244 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4