that's what I build, the left pad of the octets :)
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 3:46 PM
To: CF-Talk
Subject: Re: Sorting IP Addresses
David Delbridge wrote:
> SQL 2000 Server.
That's too bad.
Probably the easiest is to use a function that splits the octets.
Slightly harder a function left-pads the different octets.
Another option would be to convert to an integer (remember that you need all
32 bits, so a signed INT4 will not do).
Whether to convert on the fly, store in padded format or store in both
unpadded and padded format depends on the usage pattern.
(Can MS SQL Server do functional indexes?)
How do you intend to handle IPv6 addresses?
Jochem
________________________________
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- Re: Sorting IP Addresses Marlon Moyer
- Re: Sorting IP Addresses David Delbridge
- Non-Stick Session Variables? Nick Baker
- RE: Non-Stick Session Variables? Mosh Teitelbaum
- RE: Sorting IP Addresses Raymond Camden
- Re: Sorting IP Addresses Michael Dinowitz
- RE: Sorting IP Addresses Barney Boisvert
- Re: Sorting IP Addresses Jochem van Dieten
- Re: Sorting IP Addresses David Delbridge
- Re: Sorting IP Addresses Jochem van Dieten
- RE: Sorting IP Addresses Tony Weeg
- RE: Sorting IP Addresses Benjamin S. Rogers
- RE: Sorting IP Addresses Tony Weeg
- RE: Sorting IP Addresses Benjamin S. Rogers
- Re: Sorting IP Addresses Calvin Ward
- RE: Sorting IP Addresses Benjamin S. Rogers
- Re: Sorting IP Addresses Jochem van Dieten
- RE: Sorting IP Addresses Benjamin S. Rogers
- Re: Sorting IP Addresses Jochem van Dieten
- RE: Sorting IP Addresses Benjamin S. Rogers
- RE: Sorting IP Addresses Jochem van Dieten