Re: Sorting ip addresses

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 42692
interpreted = N
texte = How did you get my message when I didn't? Strange. Anyways, thanks Andrew. That's the alternative that I'll go to if needed, but would like to avoid if possible. The data is already entered into the database.Thanks, GK> Put four fields in your database and store IP's in blocks then > COL1sort=1&COL2sort=2COL3&sort=3&COL4sort=4 > > > > On 20/8/02 11:12 AM, Glenn Busbin wrote: > > >> Has anybody applied a successful sort to a range of ip addresses? I'm brain > >> dead at the moment. If I don't specify the address as a number, it sorts > >> .1, .10, ,.100, .101, .102 (<- last octets) etc. If I specify that it is a > >> number it whacks out because of the periods. Maybe a converchars to remove > >> the periods just for sorting.....? > > > > I think you need 3 digits per octet before WC will sort or do showif's > > properly. > > > > Glenn > > > > ------------------------------------------------------------- > > 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://search.smithmicro.com/ > > -- > > Andrew Simpson > Web Development > > Blackpepper Interactive Ltd > PO Box 99805 > Newmarket > > 4 Clayton Street > Newmarket > Auckland > > Ph: +64 9 520-6281 > Mob: 0272733270 > Fax: +64 9 524-1849 > > http://www.blackpepper.co.nz > > > > ------------------------------------------------------------- > 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://search.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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Sorting ip addresses (Dale Therio 2002)
  2. Re: Sorting ip addresses (Gary Krockover 2002)
  3. Re: Sorting ip addresses (Andrew Simpson 2002)
  4. Re: Sorting ip addresses (Glenn Busbin 2002)
  5. Sorting ip addresses (Gary Krockover 2002)
How did you get my message when I didn't? Strange. Anyways, thanks Andrew. That's the alternative that I'll go to if needed, but would like to avoid if possible. The data is already entered into the database.Thanks, GK> Put four fields in your database and store IP's in blocks then > COL1sort=1&COL2sort=2COL3&sort=3&COL4sort=4 > > > > On 20/8/02 11:12 AM, Glenn Busbin wrote: > > >> Has anybody applied a successful sort to a range of ip addresses? I'm brain > >> dead at the moment. If I don't specify the address as a number, it sorts > >> .1, .10, ,.100, .101, .102 (<- last octets) etc. If I specify that it is a > >> number it whacks out because of the periods. Maybe a converchars to remove > >> the periods just for sorting.....? > > > > I think you need 3 digits per octet before WC will sort or do showif's > > properly. > > > > Glenn > > > > ------------------------------------------------------------- > > 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://search.smithmicro.com/ > > -- > > Andrew Simpson > Web Development > > Blackpepper Interactive Ltd > PO Box 99805 > Newmarket > > 4 Clayton Street > Newmarket > Auckland > > Ph: +64 9 520-6281 > Mob: 0272733270 > Fax: +64 9 524-1849 > > http://www.blackpepper.co.nz > > > > ------------------------------------------------------------- > 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://search.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://search.smithmicro.com/ Gary Krockover

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:

Date fun with MySQL (2004) Bannerad Demo (1998) Add more fields to an existent data base (1997) TCP Connect for a newbie (2002) Authenticate (1997) Re:Remote stockroom ? (1998) WebMerchant 1.6 and SHTML (1997) Adding headers to email (1997) Another question about credit cards (1997) Formatting dates stored in db (2003) Image Upload? (2002) [WebDNA] WebDNA 7 and Deprecated command (2011) WebCat2 Append problem (B14Macacgi) (1997) Paradata/Moneris Gateway (2005) Nt's Latest? (1997) How about this? (1998) WebMerchant and MacAuthorize Errors (1998) using WC to create a DB online (2000) writefile and texte (1997) Gettting IPAddress (2001)