Numeric fields should only be used for numbers, not for strings that happen to be numeric. Cardinal and ordinal numbers are numeric, labels (flight numbers, phone numbers, social security numbers, zip codes, etc.) are strings. Here's the rule: if you don't perform mathematical operations on it, it's a string, even if it is made up of digits.
--- Ben -----Original Message----- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:52 PM To: CF-Talk Subject: RE: CF and SQL Its an oracle number field I believe... -----Original Message----- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:34 PM To: CF-Talk Subject: RE: CF and SQL 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. ================================ ______________________________________________________________________ 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
