RE: [WebDNA] Sorting -- Dealing with Blanks
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 100323
interpreted = N
texte = Perfect. I=92m already writing to a table so I'll try adding a "rank" = field. Thanks, Donovan. And thanks to all who responded to my question - it's = most appreciated. :) Tana -----Original Message----- From: Donovan Brooke [mailto:dbrooke@webdna.us]=20 Sent: Wednesday, July 16, 2008 11:56 AM To: talk@webdna.us Subject: Re: [WebDNA] Sorting -- Dealing with Blanks Tana Adams wrote: > Hi, > Does anyone know of a way to show all blank records for a particular=20 > field at the bottom when using the sort feature? For example, I want = to=20 > be able to sort a field, in either ascending or descending order, and=20 > always show any blank records for that particular field at the bottom. = =20 > I know I can use a showif/hideif but I was wondering if there was=20 > actually a command for that that I=92m missing within the sort feature itself. >=20 > Thanks, > Tana To always show blank records at the bottom when sorting via both = ascending and descending on text,num, or date formats is not really built in as = far as I know. You would have to first write your founditems to a table and add a simple sorting field to that table based off of simple criteria... The sort field ("RANK" perhaps) could have a value of 0 if the field is not blank, and a 1 if it is. Then search that table and do a 2 part sort. First sort would be a type=3Dnum sort on the RANK field that is always descending. The second sort would be your ascend or descend sorts. yup, that should do it. :-) Donovan --=20 Donovan D. Brooke PH/FAX: 1 (608) 291-2024 ------------------------------------------------ VP WebDNA Software Corporation 16192 Coastal Highway Lewes, DE 19958 No virus found in this incoming message. Checked by AVG.=20 Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: = 7/16/2008 6:43 AM =20 No virus found in this outgoing message. Checked by AVG.=20 Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: = 7/16/2008 6:43 AM =20
Associated Messages, from the most recent to the oldest:
Perfect. I=92m already writing to a table so I'll try adding a "rank" = field. Thanks, Donovan. And thanks to all who responded to my question - it's = most appreciated. :) Tana -----Original Message----- From: Donovan Brooke [mailto:dbrooke@webdna.us]=20 Sent: Wednesday, July 16, 2008 11:56 AM To: talk@webdna.us Subject: Re: [WebDNA] Sorting -- Dealing with Blanks Tana Adams wrote: > Hi, > Does anyone know of a way to show all blank records for a particular=20 > field at the bottom when using the sort feature? For example, I want = to=20 > be able to sort a field, in either ascending or descending order, and=20 > always show any blank records for that particular field at the bottom. = =20 > I know I can use a showif/hideif but I was wondering if there was=20 > actually a command for that that I=92m missing within the sort feature itself. >=20 > Thanks, > Tana To always show blank records at the bottom when sorting via both = ascending and descending on text,num, or date formats is not really built in as = far as I know. You would have to first write your founditems to a table and add a simple sorting field to that table based off of simple criteria... The sort field ("RANK" perhaps) could have a value of 0 if the field is not blank, and a 1 if it is. Then search that table and do a 2 part sort. First sort would be a type=3Dnum sort on the RANK field that is always descending. The second sort would be your ascend or descend sorts. yup, that should do it. :-) Donovan --=20 Donovan D. Brooke PH/FAX: 1 (608) 291-2024 ------------------------------------------------ VP WebDNA Software Corporation 16192 Coastal Highway Lewes, DE 19958 No virus found in this incoming message. Checked by AVG.=20 Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: = 7/16/2008 6:43 AM =20 No virus found in this outgoing message. Checked by AVG.=20 Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: = 7/16/2008 6:43 AM =20
"Tana Adams"
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:
total number of matches (1999)
WebCat2b15MacPlugin - [protect] (1997)
Which beta for w* 4.1 and a problem w/b12 (1999)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
Nested tags count question (1997)
[UPPERCASE] (1997)
Bad/GoodPath.inc and value of [cart]? (2000)
Showif probably dumb question (1997)
[OT] See QT? (Was Eaaaasy FTP...) (2003)
[WebDNA] random blank results? how come? (2014)
Re1000002: Setting up shop (1997)
WebCat2 - [format thousands] (1997)
[delete] problem (1997)
Shipping costs again (1998)
4.0 upgrade and existing webMerchant (2000)
[/application] error? (1997)
FM fields with CR - How to export/import? (2000)
[protect] on NT? (1997)
Math Problem - Format? (1997)
Am I going senile? (Price recalc based on quantity) (1997)