When you need all of the columns I've found using a wildcard is a speed boost. The larger the table, the greater the boost.
Does anyone know if this bug is with CF or the database driver? >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:261009 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
