(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
> > 775-832-2445
> >
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]