wouldn't sorting them using the bitwise functions make more sense on this
one?
They are binary after all.
Paul
PS Otherwise, just recreate the ip address with leading zeros, then sort
them as text and it may well sort out the problem e.g.:
216.56.6.245 -> 216.056.006.245
216.66.132.134 -> 216.066.132.134
24.16.140.8 -> 024.016.140.008
24.165.85.118 -> 024.165.85.118
24.178.211.39 -> 024.178.211.039
-----Original Message-----
From: Paris Lundis <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: 07 June 2001 07:53
Subject: sorting by IP addresses...
>So I am writing some log reporting for my enjoyment... well to make
>things a little easier to quantify...
>
>one thing I want to be ablt to do is ORDER queries by the value stored
>of the viewers IP ADDRESS...
>
>It doesn't work without some modification of the IP address... anyone
>worked on anything to do this right...
>
>for instance I get this in order:
>
>216.56.6.245
>216.66.132.134
>24.16.140.8
>24.165.85.118
>24.178.211.39
>
>not exactly right :)
>
>ideas please...
>
>-paris
>[finding the future in the past, passing the future in the present]
>[connecting people, places and things]
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
