What datatype do you have that column set to? I can help you if I know what datatype you are using.
Clint ---------- Original Message ---------------------------------- from: "Kris Pilles" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Wed, 31 Jul 2002 14:34:59 -0400 Any clue on how I can display a social security... Im having problems if the first digit is a zero.... How do I format the number so it displays all of the digits??? -----Original Message----- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:24 PM To: CF-Talk Subject: Re: CF and SQL 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. ================================ ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
