store it as a string. the only reason to store something as a numerical value (int, float, etc) is if you plan to do mathematical things to it. SSNs don't really need that, so string storage would be your best bet.
chris -----Original Message----- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:35 PM To: CF-Talk Subject: RE: CF and SQL 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. ================================ ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
