Re: Blocking off access

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 63202
interpreted = N
texte = Hi Frank The conversion worls perfectly, I am for some reason not getting a result with the search [!]Search code[/!] [Search db=ip-to-country.db&ipFromtype=num&ipTotype=num&geipFromdatarq=[ipnumber]&le ipTodatarq=[ipnumber]&max=1] [Founditems] {Insert whatever code you need to do what you want to do with the nationality data} [/Founditems] [/Search] ipFromtype ipTotype Ccode Cabr countrycode 982745088 982761471 AF AFG AFGHANISTAN 1049547296 1049547327 AF AFG AFGHANISTAN This is how the datebase is but nothing is returned Any ideas? THanks Paul ----- Original Message ----- From: "Frank Nordberg" To: "WebDNA Talk" Sent: Sunday, October 09, 2005 8:56 AM Subject: Re: Blocking off access > paul wrote: > > > The other database is in thisformat > ... > > Would need to find a way to convert dotted IPs to this > > That was the first part of the code I posted earlier: > > [TEXT]ipnumber=[MATH][LISTWORDS > words=[IPADDRESS]&delimiters=.]([WORD][SHOWIF > [INDEX]<4]*256[/SHOWIF][SHOWIF [INDEX]<3]*256[/SHOWIF][SHOWIF > [INDEX]<2]*256[/SHOWIF])+[/LISTWORDS]0[/MATH][/TEXT] > > This converts the dotted ip address collected by WebDNA to a pure > numeric value in the right format and stores it as a variable named > [ipnumber] > > I'm sure there are more elegant solutions, but this one'll work fine. > > Frank > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Blocking off access ( Dale-List 2005)
  2. Re: Blocking off access ( Terry Wilson 2005)
  3. Re: Blocking off access ( Frank Nordberg 2005)
  4. Re: Blocking off access ( "paul" 2005)
  5. Re: Blocking off access ( "paul" 2005)
  6. Re: Blocking off access ( Frank Nordberg 2005)
  7. Re: Blocking off access ( "paul" 2005)
  8. Re: Blocking off access ( Frank Nordberg 2005)
  9. Re: Blocking off access ( "paul" 2005)
  10. Re: Blocking off access ( Frank Nordberg 2005)
  11. Re: Blocking off access ( "paul" 2005)
  12. Re: Blocking off access ( Frank Nordberg 2005)
  13. Re: Blocking off access ( Frank Nordberg 2005)
  14. Re: Blocking off access ( "paul" 2005)
  15. Re: Blocking off access ( Dale-List 2005)
  16. Re: Blocking off access ( "paul" 2005)
  17. Re: Blocking off access ( "Kenneth Grome" 2005)
  18. Re: Blocking off access ( WJ Starck 2005)
  19. Re: Blocking off access ( Donovan Brooke 2005)
  20. Blocking off access ( "paul" 2005)
Hi Frank The conversion worls perfectly, I am for some reason not getting a result with the search [!]Search code[/!] [Search db=ip-to-country.db&ipFromtype=num&ipTotype=num&geipFromdatarq=[ipnumber]&le ipTodatarq=[ipnumber]&max=1] [founditems] {Insert whatever code you need to do what you want to do with the nationality data} [/Founditems] [/Search] ipFromtype ipTotype Ccode Cabr countrycode 982745088 982761471 AF AFG AFGHANISTAN 1049547296 1049547327 AF AFG AFGHANISTAN This is how the datebase is but nothing is returned Any ideas? THanks Paul ----- Original Message ----- From: "Frank Nordberg" To: "WebDNA Talk" Sent: Sunday, October 09, 2005 8:56 AM Subject: Re: Blocking off access > paul wrote: > > > The other database is in thisformat > ... > > Would need to find a way to convert dotted IPs to this > > That was the first part of the code I posted earlier: > > [text]ipnumber=[math][LISTWORDS > words=[ipaddress]&delimiters=.]([WORD][SHOWIF > [INDEX]<4]*256[/SHOWIF][SHOWIF [INDEX]<3]*256[/SHOWIF][SHOWIF > [INDEX]<2]*256[/SHOWIF])+[/LISTWORDS]0[/MATH][/TEXT] > > This converts the dotted ip address collected by WebDNA to a pure > numeric value in the right format and stores it as a variable named > [ipnumber] > > I'm sure there are more elegant solutions, but this one'll work fine. > > Frank > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ "paul"

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:

Running WebCat from a CD-ROM (1997) bug report -- leading < character (1998) corrupted images (2002) [WebDNA] site becomes unavailable and WebCatalog warnings (2017) Doing VALIDCARD right? (1998) Nav. 4 probs with cart (1997) Linux ODBC and the ODBC Bridge (2000) Hard Questions ? (1997) docs for WebCatalog2 (1997) Help w/ Duplicating The General Store 5 times. (1997) WebCatalog2 Feature Feedback (1996) Email (1998) gateway application timeouts (1998) Shopping Cart Deletion (2000) DrWatson Error! (1999) Multiple Ad databases? (1997) Multiple Merchant Accounts? (1997) Reversed words (1997) [WebDNA] Problem reading field from .db (2010) Display [price] in banner ad (1998)