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:

problems with 2 tags (1997) 2.0 Info (1997) Help! WebCat2 bug (1997) formatting dates from a field ... (1997) WebCat2 beta 11 - new prefs ... (1997) [WebDNA] [OT] economical reliable SSL certs? (2009) You sent this to me by mistake. (1998) [WebDNA] upload image files.... (2018) HTML Editors (1997) Linux ODBC and the ODBC Bridge (2000) Re:WebCatalog/WebMerchant III (1998) attachment (2000) REDIRECT MULTIPLE RESULTS (2000) Nesting format tags (1997) [WebDNA] Build Name for 6.1 (2008) RequiredFields template (1997) Formulas.db + Users.db (1997) [WebDNA] [SETMIMEHEADER] (2013) Price written to db as scientific notation??? (1999) Problems with [Search] param - Mac Plugin b15 (1997)