Do a select from the table with the ID you are going to use in the update, if the select query returns a recordcount > 0 then update it, if not then don't.
HTH Clint ---------- Original Message ---------------------------------- from: "Tangorre, Michael" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Wed, 31 Jul 2002 14:22:59 -0400 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 MillenniuM Information Systems 1101 Wilson Blvd, Suite 1200 Arlington, Virginia 22209 (703) 341-1438 ================================ This email contains MillenniuM Information Systems, LLC. privileged information. ================================ ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
