Re: IP Logging DB Data Type???
Ahh thanx alot!!! Your explanation is a great help. Actually I did end up using TEXT as the data type after numerous attempts of trying different numeric data types that just werent working out. Thanx again for the help. Sincerely, Mike From: "HSMN Main Account" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: IP Logging DB Data Type??? Date: Mon, 04 Dec 2000 01:37:44 -0500 Structure it as a TEXT field. The only reason to set up a field as any kind of number is if you expect to do some kind of mathematical operation on it. If you are not, then it is not really a number, it just LOOKS like one. Failure to understand the difference is a common mistake that database designers make. I do a lot of work in the Medical field and one of the biggest problems I see is that databases are often designed so that Medical record "numbers", and another "number" called a DRG are often structured as numeric types. There are times with these and other "numbers" that are used only as identifiers require the leading zeros, or some sorting algorhythm where the position of each digit is important. I don't see anyway to store an IP address as a number anyway. It COULD be stored in four separate numberic fields, but why bother? The only exception to this is when a process has to generate the id number based on a sequence of some kind, but then it should usually be converted to a string for subsequent use. - Original Message - From: "Michael Thomas" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, December 02, 2000 4:04 AM Subject: IP Logging DB Data Type??? I have a quick question about IP logging. I want to log an IP address into a database but Im not sure which is the correct data type to use. Will Float do it or Double Precision??? BTW Im going to have to do this for MS Access SQL Server 7.0 so I'll need the correct data type for each one. Im using MS Access 97 for testing purposes but the live database will be an SQL Server 7.0 DB. TIA, Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IP Logging DB Data Type???
Structure it as a TEXT field. The only reason to set up a field as any kind of number is if you expect to do some kind of mathematical operation on it. If you are not, then it is not really a number, it just LOOKS like one. Failure to understand the difference is a common mistake that database designers make. I do a lot of work in the Medical field and one of the biggest problems I see is that databases are often designed so that Medical record "numbers", and another "number" called a DRG are often structured as numeric types. There are times with these and other "numbers" that are used only as identifiers require the leading zeros, or some sorting algorhythm where the position of each digit is important. I don't see anyway to store an IP address as a number anyway. It COULD be stored in four separate numberic fields, but why bother? The only exception to this is when a process has to generate the id number based on a sequence of some kind, but then it should usually be converted to a string for subsequent use. - Original Message - From: "Michael Thomas" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, December 02, 2000 4:04 AM Subject: IP Logging DB Data Type??? I have a quick question about IP logging. I want to log an IP address into a database but Im not sure which is the correct data type to use. Will Float do it or Double Precision??? BTW Im going to have to do this for MS Access SQL Server 7.0 so I'll need the correct data type for each one. Im using MS Access 97 for testing purposes but the live database will be an SQL Server 7.0 DB. TIA, Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
IP Logging DB Data Type???
I have a quick question about IP logging. I want to log an IP address into a database but Im not sure which is the correct data type to use. Will Float do it or Double Precision??? BTW Im going to have to do this for MS Access SQL Server 7.0 so I'll need the correct data type for each one. Im using MS Access 97 for testing purposes but the live database will be an SQL Server 7.0 DB. TIA, Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists