Yes, but all the last name values should match throughout our databases, therefore, it doesn't really matter which exact column I choose, as long as I choose one of them.
Someone else may have touched on the best answer. Many programmers may not know what "sn" is, but they should all know what "lastName" is. So, not only is consistency a good thing, so is clarity. ;-) I'm probably better off aliasing the column names to help the other guys. Thanks for everyone's input. M!ke -----Original Message----- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 1:10 PM To: CF-Talk Subject: RE: Inconsistent Variable Names Across Data Sources Actually... I don't really see a reason to alias in the cross joins either. If they are all the same value, wouldn't you just select the one you wanted to use? ...:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:299351 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
