IP address and Country

harrison at all-auctions.com harrison at all-auctions.com
Sun Nov 27 18:06:53 EST 2022

Hi Kee,

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



> 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

More information about the use-livecode mailing list