Paris,
I imagine if you are writing some log analyzing software that you are
dumping the logs into a database for easier analysis ?
If you are dumping them into a database then you should just do some simple
string parsing to break the IP address up into 4 "tiny int" fields in this
way you'll be able to do any sort of funky processing you want to them.
Or to get really freaky why not process them back into their 32 bit binary
representations <grin>
If you want some SQL ideas just let me know.
-eric
----- Original Message -----
From: "Paris Lundis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 07, 2001 2:35 AM
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
