Re: sorting month by month

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59125
interpreted = N
texte = [search db=your.db&neDATEFIELDdatarq=[blank]&asDATEFIELDSORT=1&DATEFIELDTYPE=date] will sort your records in ascending order by date. Are you wanting to find "just" April records (for example)? [text show=f]monthstart=04/01/2004[/text] [text show=f]monthend=04/30/2004[/text] [search db=your.db&rnDATEFIELDdatarq=[monthstart] [monthend]&asDATEFIELDSORT=1&DATEFIELDTYPE=date] Is one example. GK At 02:41 PM 8/21/2004, you wrote: >Hello! in a WebDNA database, the dates have the classical mm/dd/yy form. > >What would be the proper search code to sort a full month, for instance >"sort all January 2003 records" or "sort all April 2004 records" ? > >Thank you! >chris ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: sorting month by month ( Kenneth Grome 2004)
  2. Re: sorting month by month ( Gary Krockover 2004)
  3. sorting month by month ( Chris 2004)
[search db=your.db&neDATEFIELDdatarq=[blank]&asDATEFIELDSORT=1&DATEFIELDTYPE=date] will sort your records in ascending order by date. Are you wanting to find "just" April records (for example)? [text show=f]monthstart=04/01/2004[/text] [text show=f]monthend=04/30/2004[/text] [search db=your.db&rnDATEFIELDdatarq=[monthstart] [monthend]&asDATEFIELDSORT=1&DATEFIELDTYPE=date] Is one example. GK At 02:41 PM 8/21/2004, you wrote: >Hello! in a WebDNA database, the dates have the classical mm/dd/yy form. > >What would be the proper search code to sort a full month, for instance >"sort all January 2003 records" or "sort all April 2004 records" ? > >Thank you! >chris ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Gary Krockover

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:

lookups (2000) Some shell fun (2004) Extended [ConvertChars] (1997) supressing math results (1997) [protect] on NT? (1997) [WebDNA] Passing a text variable via copyfile (2019) Re:no [search] with NT (1997) WebCatalog for Postcards ? (1997) [WebDNA] Ubuntu 18.04 & Apache2 & WebDNA fcgi - File upload error (2019) [WebDNA] OT - does anyone know how to get Fetch/BBedit to leave (2009) About the hyphen in searches (2003) [SHOWIF AND/OR] (1997) credit card (1997) Show shoppingcart after remove last item (1997) Multiple Replaces? (1997) Emailer Set Up (1997) list items (1998) Opinion: [input] should be called [output] ... (1997) SiteGaurd file Cache vs webcatalog cache (1997) SpiderBotLock! (2003)