IP address and Country

[harrison at all-auctions.com]

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 <use-livecode at lists.runrev.com> 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