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:
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:
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
HELP WITH DATES (1997)
Referrer from multiple entry points (1998)
foreign languages, email, webcat (1998)
searchable list archive (1997)
SHOWNEXT (1999)
Test .... (2002)
Browser / Mime Type mapping problem. (2000)
Webcatalog server support (1997)
template not found error (1998)
Online reference (1997)
Trouble Searching (1999)
Email notification to one of multiple vendors ? (1997)
OK, here goes... (1997)
SKU (1997)
WebCat hosting providers? (1997)
Runnaway Trigger (2007)
Bulk Register (2004)
PCS Frames (1997)
[WebDNA] Can WebDNA corrupt a db? (2012)