[WebDNA] anyone get MaxMind geolite city working?

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 108647
interpreted = N
texte = This is a multi-part message in MIME format. --------------040706090003000500060709 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Trying to build a system to convert and IP address to a city. Here is a free dataset: http://www.maxmind.com/app/geolitecity. The set has 3.5 million records which I converted to tab d databases. I can search it but the results are funky. thisnum = converted IP address This brings back a bad result: [search db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]] found = [numfound]
[foundItems] [startipnum] - [thisnum] -[endipnum] [/foundItems] [/search] Result is: 999,997,440 - 1,224,592,000 - 1,000,007,167 The number in the middle should be between the left and right number. When I add in the num data type, I get no results (search db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]&startIPnumtype=num&endIpNumtype=num]). Anyone work with this data set before? Thanks, Olin --------------040706090003000500060709 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Trying to build a system to convert and IP address to a city. Here is a free dataset: http://www.maxmind.com/app/geolitecity. The set has 3.5 million records which I converted to tab d databases. I can search it but the results are funky.

thisnum = converted IP address

This brings back a bad result:
[search db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]]
        found = [numfound]<br />
        [foundItems]
        [startipnum] - [thisnum] -[endipnum]
        [/foundItems]
[/search]
   

Result is: 999,997,440 - 1,224,592,000 - 1,000,007,167

The number in the middle should be between the left and right number. When I add in the num data type, I get no results (search db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]&startIPnumtype=num&endIpNumtype=num]).

Anyone work with this data set before?

Thanks, Olin
 --------------040706090003000500060709-- Associated Messages, from the most recent to the oldest:

    
  1. [WebDNA] anyone get MaxMind geolite city working? (Olin Lagon 2012)
This is a multi-part message in MIME format. --------------040706090003000500060709 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Trying to build a system to convert and IP address to a city. Here is a free dataset: http://www.maxmind.com/app/geolitecity. The set has 3.5 million records which I converted to tab d databases. I can search it but the results are funky. thisnum = converted IP address This brings back a bad result: [search db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]] found = [numfound]
[founditems] [startipnum] - [thisnum] -[endipnum] [/foundItems] [/search] Result is: 999,997,440 - 1,224,592,000 - 1,000,007,167 The number in the middle should be between the left and right number. When I add in the num data type, I get no results (search db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]&startIPnumtype=num&endIpNumtype=num]). Anyone work with this data set before? Thanks, Olin --------------040706090003000500060709 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Trying to build a system to convert and IP address to a city. Here is a free dataset: http://www.maxmind.com/app/geolitecity. The set has 3.5 million records which I converted to tab d databases. I can search it but the results are funky.

thisnum = converted IP address

This brings back a bad result:
[search db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]]
        found = [numfound]<br />
        [founditems]
        [startipnum] - [thisnum] -[endipnum]
        [/foundItems]
[/search]
   

Result is: 999,997,440 - 1,224,592,000 - 1,000,007,167

The number in the middle should be between the left and right number. When I add in the num data type, I get no results (search db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]&startIPnumtype=num&endIpNumtype=num]).

Anyone work with this data set before?

Thanks, Olin
 --------------040706090003000500060709-- Olin Lagon

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

wc 2 pro users - sites, quotes wanted (1997) re: date search problem (1999) Download (1999) Windows 2.1b2 Append Bug? (1997) [include ...] behavior (1997) Repost: Orderfile, Grandtotal: How do I get it to all add up. (2000) security problem (1997) PIXO (1997) Authenticate (1997) Where's Cart Created ? (1997) [OT] Robust order processing (2003) Hello??? (1997) taxTotal problem (1998) Re1000001: Setting up shop (1997) Nesting WebDNA in JavaScript (2003) Re[2]: 2nd WebCatalog2 Feature Request (1996) RE: creating writefile data from a nested search (1997) Secure Server (1997) WC TableGrinder (1997) View order not right (1997)