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 =mostappreciated. :)Tana-----Original Message-----From: Donovan Brooke [mailto:dbrooke@webdna.us]=20Sent: Wednesday, July 16, 2008 11:56 AMTo: talk@webdna.usSubject: Re: [WebDNA] Sorting -- Dealing with BlanksTana 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 featureitself.>=20> Thanks,> TanaTo always show blank records at the bottom when sorting via both =ascendingand descending on text,num, or date formats is not really built in as =far asI know. You would have to first write your founditems to a table and adda simple sorting field to that table based off of simple criteria...The sort field ("RANK" perhaps) could have a value of 0 if thefield 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 thatis always descending. The second sort would be your ascend or descendsorts.yup, that should do it. :-)Donovan--=20Donovan D. Brooke PH/FAX: 1 (608) 291-2024------------------------------------------------VPWebDNA Software Corporation16192 Coastal HighwayLewes, DE 19958No virus found in this incoming message.Checked by AVG.=20Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: =7/16/20086:43 AM=20No virus found in this outgoing message.Checked by AVG.=20Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: =7/16/20086: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 =mostappreciated. :)Tana-----Original Message-----From: Donovan Brooke [mailto:dbrooke@webdna.us]=20Sent: Wednesday, July 16, 2008 11:56 AMTo: talk@webdna.usSubject: Re: [WebDNA] Sorting -- Dealing with BlanksTana 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 featureitself.>=20> Thanks,> TanaTo always show blank records at the bottom when sorting via both =ascendingand descending on text,num, or date formats is not really built in as =far asI know. You would have to first write your founditems to a table and adda simple sorting field to that table based off of simple criteria...The sort field ("RANK" perhaps) could have a value of 0 if thefield 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 thatis always descending. The second sort would be your ascend or descendsorts.yup, that should do it. :-)Donovan--=20Donovan D. Brooke PH/FAX: 1 (608) 291-2024------------------------------------------------VPWebDNA Software Corporation16192 Coastal HighwayLewes, DE 19958No virus found in this incoming message.Checked by AVG.=20Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: =7/16/20086:43 AM=20No virus found in this outgoing message.Checked by AVG.=20Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: =7/16/20086: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:
hidden databases (2000)
Protect (1997)
[Announce] Newest Commerce Site based on WebCatalog (1997)
Include a big block of text (1997)
WebCatalog Plugin: Getting Data Canceled (2000)
[OT] XServe networking PITA (2004)
Recursion & WebDNA (1999)
email [title] (1997)
frames & carts (1997)
test (2001)
WC2/Mac -- Forms not submitting correctly with Mac browsers (1997)
WebCatalog 2.0 b 15 mac (1997)
Don't know if this is a sily question... (2003)
WebCatalog not recognizing ShoppingCarts folder (2000)
New Command prefs ... (1997)
WebCatalog can't find database (1997)
SSL and WebCatalog (1997)
Refering page (1998)
[WebDNA] Still having problems (2008)
YACBQ.....(Yet another checkbox question) (2000)