Nice access tip. I'd never heard that one. Plus as the db evolves, what was once a small amount of fields returned by * might become much bigger. Espeically if more memos or large text fields are added.
DRE -----Original Message----- From: Sandy Clark [mailto:slLists@;shayna.com] Sent: Thursday, October 17, 2002 3: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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
