I had the exact same problem. I don't know if it's an option for you, but I
ended up storing the four octets seperately. Then simply doing a sort on
"IPOctet1, IPOctet2, IPOctet3, IPOctet4".
Norman
-----Original Message-----
From: Paris Lundis [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2001 2:36 AM
To: CF-Talk
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
