RE: [WebDNA] Sorting -- Dealing with Blanks

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 100326
interpreted = N
texte = Yep. That works great as well. Thanks! Tana -----Original Message----- From: Matthew Bohne [mailto:matthew.bohne@benetela.com] Sent: Wednesday, July 16, 2008 12:30 PM To: talk@webdna.us Subject: Re: [WebDNA] Sorting -- Dealing with Blanks Just use two [founditems] in your search. [search db=whatever.db&neskudatarq=[blank]&asMightBeBlankFieldsort=1] [founditems] [hideif [MightBeBlankField]=] [sku] - [MightBeBlankField] [/hideif] [/founditems] [founditems] [showif [MightBeBlankField]=] [sku] - [MightBeBlankField] [/showif] [/showitems] [/search] Donovan Brooke wrote: > Donovan Brooke wrote: > [snip] >> 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=num sort on the RANK field that >> is always descending.[snip] > > > Correction: ...s/b "always ascending" > > D > > > > No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: 7/16/2008 6:43 AM No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: 7/16/2008 6:43 AM Associated Messages, from the most recent to the oldest:

    
  1. RE: [WebDNA] Sorting -- Dealing with Blanks ("Tana Adams" 2008)
  2. Re: [WebDNA] Sorting -- Dealing with Blanks (Matthew Bohne 2008)
  3. RE: [WebDNA] Sorting -- Dealing with Blanks ("Tana Adams" 2008)
  4. Re: [WebDNA] Sorting -- Dealing with Blanks (Donovan Brooke 2008)
  5. Re: [WebDNA] Sorting -- Dealing with Blanks (Donovan Brooke 2008)
  6. Re: [WebDNA] Sorting -- Dealing with Blanks (Charles Kline 2008)
  7. RE: [WebDNA] Sorting -- Dealing with Blanks ("Tana Adams" 2008)
  8. Re: [WebDNA] Sorting -- Dealing with Blanks (Gary Krockover 2008)
Yep. That works great as well. Thanks! Tana -----Original Message----- From: Matthew Bohne [mailto:matthew.bohne@benetela.com] Sent: Wednesday, July 16, 2008 12:30 PM To: talk@webdna.us Subject: Re: [WebDNA] Sorting -- Dealing with Blanks Just use two [founditems] in your search. [search db=whatever.db&neskudatarq=[blank]&asMightBeBlankFieldsort=1] [founditems] [hideif [MightBeBlankField]=] [sku] - [MightBeBlankField] [/hideif] [/founditems] [founditems] [showif [MightBeBlankField]=] [sku] - [MightBeBlankField] [/showif] [/showitems] [/search] Donovan Brooke wrote: > Donovan Brooke wrote: > [snip] >> 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=num sort on the RANK field that >> is always descending.[snip] > > > Correction: ...s/b "always ascending" > > D > > > > No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: 7/16/2008 6:43 AM No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: 7/16/2008 6:43 AM "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:

WebCat2_Mac RETURNs in .db (1997) Multiple catalog databases and showcart (1997) Multiple Users.db Possible? (1997) Re:quit command on NT (1997) WebDNA maxing out processor (2008) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) [ShowIf] and empty fields (1997) Tracking System? (1997) Add htmlarea 3 to SiteBuilder (2004) month or year in date field in lineitems continued... (1998) Country & Ship-to address & other fields ? (1997) WebDNA Windows 5.0 sendmail bug (2003) WebTEN vs webSTAR have you seen this? (1998) Dumb Question about Docs (1997) Format question WC Mac f3 (1997) Where is f2? (1997) Showif, Hideif reverse logic ? (1997) Type 11 errors setting up WebCAt 2 (1997) Product display (2000) RAM crash (1998)