I'd just store it as a text.. another option would be to store it as a
number and use CF to format it correctly
On 1/3/06, Brian Coleman [EMAIL PROTECTED] wrote:
I have a CF application I'm working on and part of the application has entry
of phone numbers. I think this may be related more to
I don't think you can make an INT field take leading 0's
Not sure if any numeric field will take leading 0's
Been down that road, I went with varchars for my phone fields.
J
On 1/3/06, Brian Coleman [EMAIL PROTECTED] wrote:
I have a CF application I'm working on and part of the application
My phone fields are broken up into 3 parts, area code, prefix
and phone number. Each of those sections are a field in the
DB, so 3 fields for a phone number. The fields are integer type.
Phone number fields should be character data, not numeric. You should only
use numeric fields for values
: Tuesday, January 03, 2006 11:10 AM
To: CF-Talk
Subject: RE: phone numbers in database
My phone fields are broken up into 3 parts, area code, prefix
and phone number. Each of those sections are a field in the
DB, so 3 fields for a phone number. The fields are integer type.
Phone number fields
The only issue with that would be sorting them numerically versus
alphabetically
0
1
10
2
20
3
30
Would be what youd get with these numbers alphabetically instead of
numerically...
If they're phone numbers, I suspect they all have the same number of digits,
so I don't see why that
If they are all US numbers that would most likely be true.
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 03, 2006 11:29 AM
To: CF-Talk
Subject: RE: phone numbers
: Tuesday, January 03, 2006 11:41 AM
To: CF-Talk
Subject: RE: phone numbers in database
If they are all US numbers that would most likely be true.
...:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED
]
Sent: Tuesday, January 03, 2006 11:03 AM
To: CF-Talk
Subject: RE: phone numbers in database
But then again, I guess he would have said there was a 4th field for a
possible country code so you're probably right... It would sort fine
either
way.
If they are all in fact 3, 3 and 4 digits you could
-Talk
Subject: RE: phone numbers in database
That is true, they are all US numbers and the same type of digits. I
doubt they'd ever do any kind of searches on them. I think I'll switch
it to be 1 field of text and slightly change the way it's entered.
Thanks All
-Original Message-
From
Brian Coleman wrote:
My phone fields are broken up into 3 parts, area code, prefix and phone
number. Each of those sections are a field in the DB, so 3 fields for a phone
number. The fields are integer type.
Let's see how that would work with my phone number:
+31 10 75 01888 991
| | |
10 matches
Mail list logo