I'm not sure if the terms 'passive' and 'active' are correct, I think I heard it somewhere, but...
.... passive will generate code that you take and use somewhere, active will mess with the actual code. If anyone knows different, pipe up! Adrian -----Original Message----- From: Denny Valliant [mailto:[EMAIL PROTECTED] Sent: 18 April 2006 01:59 To: CF-Talk Subject: Re: 19 >= 19 - query error On 4/16/06, Adrian Lynch <[EMAIL PROTECTED]> wrote: > > Nope, I use a passive code generator. Less risky :O) Passive? Generation is generation, man! Heh. What do you mean? "Incoming! (Heh. Not often is it the other guys yelling that)" > > No comment on the friendly fire! :O. Oooo! Good point. Not as funny an idea tho, see... "look out bad guys, a grenade is rolling your way!" "You may want to duck, as I'm shooting at you!" A callback to a bygone age. Like vaudville. Damn Sun Tzu... [ = Sorry. Old war stuff on PBS, don't'cha know... -----Original Message----- > From: Denny Valliant [mailto:[EMAIL PROTECTED] > Sent: 16 April 2006 04:41 > To: CF-Talk > Subject: Re: 19 >= 19 - query error > > > 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:238050 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
