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:

weirdness in the error log (1998) [OT] Invoking a MP3 Download (2004) Targeting [redirect] to a frame? (1998) date formatting for CC card expiration date check (1998) bug report -- leading < character (1998) Upgrading old WebCat Database Files (1997) plugin-acgi, different results (1997) Nesting format tags (1997) Help name our technology! I found it (1997) READFILE command? (1998) ReturnRaw and redirect (1997) Ok here is a question? (1997) PCS Frames (1997) ImageMap (1997) New to WebCat-very unsure (2000) Enterprise Server (1998) [WebDNA] Grep everything and replace with asterisks? (2010) test (2003) Using Plug-In while running 1.6.1 (1997) Interfacing WC with mail server (1998)