Again, you cant say its not sloppy - it isn't. Sloppy is an opinion - I find people who do this sloppy:
Select [columnlists] from table, table b - I mean, have they not heard of JOIN syntax? And any best practice document may be someone else's list of don'ts. And more often than not you will of course know what columns you are getting back - its normally your own database! And if you don't know it by now.....;-) -----Original Message----- From: Al Everett [mailto:[EMAIL PROTECTED] Sent: 20 July 2005 16:41 To: CF-Talk Subject: Re: CFQuery and SQLBase - alternative to using asterisk It's still sloppy. For one thing, there's no way to tell what columns you're getting back unless you look at the table as well. I find it very rare that I need all columns from any table. Any best practice document I've seen on SQL says to avoid SELECT *. On 7/20/05, Claude Schneegans <[EMAIL PROTECTED]> wrote: > >>You shouldn't ever use SELECT *. Name the columns you want. > > Well, ... except if you do need all columns, and SELECT * is standard in > SQL, especially for that purpose. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212323 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54