Re: IP address and Country

[harrison--- via use-livecode]

Hi Kee,

I did solve it, I just forgot to tell the list that I did.  Oops.

Thanks!

Rick



> On Nov 27, 2022, at 4:17 PM, kee nethery via use-livecode 
>  wrote:
> 
> When we did this, the database table had a start and end IP address range 
> column.
> 
> The IP addresses were entered into the table as integers without the dots. 
> I’m not sure but I think we might have put a “1” at the beginning of the IP 
> address integers so that everything stayed 13 digits (ie the front zeros in 
> an IP address were not eliminated).
> 
> StartIP and EndIP columns were indexed.
> 
> The lookup time was pretty quick. 
> 
> Kee Nethery

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: IP address and Country

[kee nethery via use-livecode]

When we did this, the database table had a start and end IP address range 
column.

The IP addresses were entered into the table as integers without the dots. I’m 
not sure but I think we might have put a “1” at the beginning of the IP address 
integers so that everything stayed 13 digits (ie the front zeros in an IP 
address were not eliminated).

StartIP and EndIP columns were indexed.

The lookup time was pretty quick. 

Kee Nethery
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode