On 4/14/06, Adrian Lynch <[EMAIL PROTECTED]> wrote: > > And to balance out the argument some, writing all the columns takes longer > to write! > > Go on, fire away, I'm in my bunker and the flaps are down :OD > > Adrian
Incoming! (Heh. Not often is it the other guys yelling that) Why wouldn't you write out columns? Isn't all your SQL generated? O.o Surely you're not actually hard-coding names... right? You do have just one place where if you change a field name, it updates the forms, the SQL... basically everything where that name was referenced? Then you can force your DB person use your CF code to manipulate the DB. They love that. Really. :Deni -----Original Message----- > From: Ben Nadel [mailto:[EMAIL PROTECTED] > Sent: 14 April 2006 20:32 > To: CF-Talk > Subject: RE: 19 >= 19 - query error > > > Rick, > > This is the easiest problem in the world to fix.... > > Don't use SELECT *. > > Name the column in the select statement. Not only does this cut out your > problem, it also: > > 1. Makes the select statement more clear to anyone else reading. > 2. Increases speed of the query. > 3. Decreases the amount (most likely) of info that SQL has to transfer to > the CF memory space. > > Cheers, > ben > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237820 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
