Re: [WebDNA] Sorting -- Dealing with Blanks

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 100324
interpreted = N
texte = 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 > > > > 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)
  9. [WebDNA] Sorting -- Dealing with Blanks ("Tana Adams" 2008)
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 > > > > Matthew Bohne

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:

headers (2004) WebDNA Verison 4.5 will Not Restart! This SUCKS! (2002) Make sure I understand this??? (1997) [WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011) shipcost (1997) math problems (2000) Include a big block of text (1997) Searching multiple Databases (1997) Major Security Hole (1998) WebTen + WebCatalog Plugin clarification (1998) Merry Christmas (2002) SSL and Webcat (2000) Replace context problem ... (1997) Extracting a filename (2004) Blank orders after update to 5.1 (2003) Bad Cookie / Internet Option / Internet Explorer (2004) XML Syntax, Cookies and Variables.... (2004) Associative lookup style? (1997) OT : Site speed feedback (2002) Empty Shopping Carts? (1998)