strips the .'s out
makes it one big number
166.141.23.1
166.141.23.10
166.141.23.2
166.141.23.20
and then you could order them because they then become
166141023001
166141023002
166141023010
166141023020
so that we can store it in sql server, as a bigInt, maybe you could use it
inline
during the looping through the query results to establish an order? then go
from there?
make sense?
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-----Original Message-----
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 3:37 PM
To: CF-Talk
Subject: RE: Sorting IP Addresses
Then you'd have to figure out how to put the "periods" back in... in the
right places. :-)
-----Original Message-----
From: David Delbridge [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 3:34 PM
To: CF-Talk
Subject: Re: Sorting IP Addresses
Thanks, guys. Unfortunately, everything must happen in the query itself (or
at the SQL server) because I'm using a custom tag which takes a raw SQL
query as input and spits out the results in a particularly-formatted (and
quite attractive) table. Hence, there is not a place for me to manipulate
the data via CF.
I like Raymond's link, though. I wonder if I couldn't strip the punctuation
and convert to integer in the query, rather than parse out each octet?
Hmmm...
Dave
Michael Dinowitz wrote:
>
> There are 2 ways I can think of. The first is to get the IPs and then
> write an IPSort() function to do the sorting for you post query. The
> second is to have SQL parse each IP part into it's own var and sort on
> each of the vars.
> Ugly as sin, but....
>
> > Hi all,
> >
> > I have some lengthy tables filled with IP addresses. Given that the
> IP
> > addresses are contained in a single text field (and not four
> individual
> > octet fields), what would be the SIMPLEST way to sort those IPs in a
> SQL
> > query?
> >
> > For example, 'SELECT IP FROM IP_TABLE ORDER BY IP' produces the
> > following sort order:
> >
> > 123.123.123.10
> > 123.123.123.11
> > 123.123.123.2
> > 123.123.123.20
> > 123.123.123.21
> > 123.123.123.3
> >
> > But, of course, the desired results would instead be:
> >
> > 123.123.123.2
> > 123.123.123.3
> > 123.123.123.10
> > 123.123.123.11
> > 123.123.123.20
> > 123.123.123.21
> >
> > Any help is greatly appreciated.
> >
> > Dave
> >
> > --
> >
> > David M. Delbridge
> > Circa 3000
> > ColdFusion Hosting
> > http://www.circa3k.com <http://www.circa3k.com>
> > 775-832-2445
> >
>
_____
________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
