> ARRGGHH!! Is this a CF issue or an Access database driver issue? > > http://azarflooringgallery.com/bud.cfm > > This is a very simple, and quite standard query. > > SELECT M.*,C.* > FROM Main_Categories M LEFT OUTER JOIN Categories C on > M.Main_Category_ID = C.Main_Category_ID > > Note the Main_Category_ID is being returned with the alias in > it's name. The field is actually named Main_Category_ID > > C.Main_Category_ID and M.Main_Category_ID > > I'm getting the error Variable MAIN_CATEGORY_ID is undefined. > > I can get it to go away, but only if I manually enter all > field names and exclude Main_Category_ID from one of the tables. > > Why would someone change the behavior of something so drastically? > This will be affecting code everywhere.
Generally, in most database environments, you can't specify the same field twice unless you alias it at least once. If you could do this before, you shouldn't have been able to. I suspect that the database or driver is renaming both of the fields for you, to prevent an error from occurring - if you dump the query, you might be able to see this. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore and Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260860 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
