Select * is for whimps, where they write a couple basic sql statements. select with column names is for the cool kids in town where we'd rather write it in SQL vs writing all those *Arrays, Structures, Multidimensional Arrays & Arrays of Structures***.
That's a slight crack on Kurtis D. Leatham<http://www.cfunited.com/speakers.cfm#249>. His session was awesome at cfunited, but those things can be eliminate to an extent with good sql. Writing basic SQL, who cares. use *, Writing hefty statements, with lots of joins and stuff, use table names. Casey On 7/11/06, Jim <[EMAIL PROTECTED]> wrote: > > Oh yes, when you go out to troubleshoot other companies apps you > certainly do come across many more problems. > > Not a good example of where explicit alias + naming would have been handy? > OK, sorry bout that. > > > Claude Schneegans wrote: > > >>Someone adds a column to one of the tables in the query that has the > > same name as a column in another of the tables in the query. > > > > If you're working in an environment in which any one can add columns or > > modify a table > > without othe programers being aware, then you will have have many more > > problems ;-) > > > > And what if some one just change the name of a column? > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/cf_lists/message.cfm/forumid:4/messageid:246136 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
