Bud, I am by no means trying to put salt on your wounds, but usage of wild cards is not really good practice. They is not really any marginal speed boost by not declaring the names of the column, but if you do not use all of the columns, then every column not added to your select clause will save time.
Teddy On 11/17/06, Bud <[EMAIL PROTECTED]> wrote: > > 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. > -- > > Bud Schneehagen - Tropical Web Creations, Inc. > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > Web Based Solutions / eCommerce Development & Hosting > http://www.twcreations.com/ - http://www.cf-ezcart.com/ > Toll Free: 877.207.6397 - Local & Int'l Phone/Fax: 386.789.0968 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:260851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
