Quite true.......Of course, if you actually intend to select all fields, using * is actually faster than writing out the fieldnames. I might be wrong, but I think I read this somewhere. Please correct me if I am thanks.
-----Original Message----- From: Sandy Clark [mailto:slLists@;shayna.com] Sent: Thursday, October 17, 2002 4:21 PM To: CF-Community Subject: RE: Big "dummy" flags Speaking of queries. Using Select * is usually the signal for either a novice or a newbie. Always write out the fieldnames. Two reasons. 1) if you are only selecting a few fields from a table then the overhead of retrieving everything is going to bog down your query. 2) if you select by fieldnames, then you can determine the order in which items are retrieved. This is especially important if you are using memo fields in Access or large text fields in other databases because the database has to retrieve those as unbound fields (which is slower) and after retrieving one unbound field, it will retrieve every other field named after that one as unbound as well. -----Original Message----- From: Nick McClure [mailto:cf-lists@;king-nacho.com] Sent: Thursday, October 17, 2002 2:25 PM To: CF-Community Subject: RE: Big "dummy" flags I hate CFabort. And not writing your own Queries. CFInsert and Update are ok sometimes, but it can't take the place of writing the query your self. > -----Original Message----- > From: Candace Cottrell [mailto:CottrellC@;childrensdayton.org] > Sent: Thursday, October 17, 2002 12:49 PM > To: CF-Community > Subject: Big "dummy" flags > > As you all probably know, I am fairly new to CF. > > So, I have a client who wants to see a code sample. Are there any "what > a big dummy" flags in cf code that would cause the person to cringe? > > TIA > > Candace K. Cottrell, Web Developer > The Children's Medical Center > One Children's Plaza > Dayton, OH 45404 > 937-641-4293 > http://www.childrensdayton.org > > > [EMAIL PROTECTED] > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
