If you DB supports it, use if exists [query]
the presence of the exists directive will cause the query to stop processing as soon as it has a match. This can save time if you are querying an unindexed table or there are multiple results. Justin > -----Original Message----- > From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 2:23 PM > To: CF-Talk > Subject: CF and SQL > > Ok, > > I am interested in peoples opinions on the following: > > Is it best practice to check for a records existence before > attempting to update it? > And what would the best way to go about that be? > > Michael Tangorre > ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
