Re: Sorting ip addresses

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 42702
interpreted = N
texte = Any suggestions on how to pad any octets that don't have 3 numbers with leading 0's?Then you should be able to store the entire IP address in one field and sort that way. On Tuesday, August 20, 2002, at 01:16 AM, Andrew Simpson wrote:> 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. >> >> GlennDale ------------------------------------------------------------- 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)
Any suggestions on how to pad any octets that don't have 3 numbers with leading 0's?Then you should be able to store the entire IP address in one field and sort that way. On Tuesday, August 20, 2002, at 01:16 AM, Andrew Simpson wrote:> 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. >> >> GlennDale ------------------------------------------------------------- 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/ Dale Therio

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:

[OT] Accepting Credit Cards Online (1999) Erotic Sites (1997) Design Help Needed (1998) Multiple Pulldowns/Gary (1997) WebCatalog for Dummies part 2 (2000) HELP WITH DATES (1997) form data submission gets truncated (1997) triggering an update of two frames (1998) Include a big block of text (1997) Templates on Unix & CGI on Mac? (1997) WebCat2b15MacPlugin - showing [math] (1997) Running 2 two WebCatalog.acgi's (1996) Pulling Captions from JPGs (2003) Cart questions (1997) Where's Cart Created ? (1997) 2nd WebCatalog2 Feature Request (1996) Cookies, checking if's enabled... (2004) [WebDNA] Yet another call for hosts... (2009) Re[2]: Wierd problem with 3.08 WIN Version (2000) Practice runs ? (1997)