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:

OS X Line Endings HELL [solved] (2003) emailer w/F2 (1997) Apache 2.0 question (AddModule mod_webcatalog.cpp) (2008) Looking for WebSTAR bomb at startup (2000) Initiating NewCart (1997) [WebDNA] Search Problem (2011) Include vs. lookup? (1998) 2 Nt's (1998) Webstar 1.3.1 PPC (1997) Help with ShowNext (1998) taxrate - off by 1 cent (1997) MacAuthorize order data fields WAS:How To question... (1997) Re:Copyright ? (1997) E-mailer error codes (1997) WebCatalog2 Feature Feedback (1996) Newbie Tax Question (1997) PSC recommends what date format yr 2000??? (1997) Opinion: [input] should be called [output] ... (1997) WebCat B13 Mac CGI -- Frames question (1997) Sku numbers (1997)