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:

WCS Newbie question (1997) WebCatalog/WebMerchant 2.1 (1998) Next X hits (1996) Out of the woodwork (2007) RE: Problem (1997) emailer (1997) Multiple fields on 1 input (1997) Email Set-Up? (1997) Hiding HTML and page breaks (1997) [Sum] function? (1997) [WebDNA] encrypt files/directories (2011) Nested tags count question (1997) international time (1997) Dreamweaver Extensions for WC (2000) Fwd: checkboxes (2000) [WebDNA] Good advise on [Showif] or alternative... (2012) Showif for mulitple variations (1997) Erotic Sites (1997) Web Catalog vs. ICAT (1997) [if] and [showif] - A solution (2002)