Date Sort question

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59470
interpreted = N
texte = Hi, Thanks to all for the help with the rotating photo gallery, I'm still waiting for the client to confirm....meanwhile, I have to ask about sorting/comparing by date. I am viewing db contents of calendar reservation events in an html table, and I wish to sort by various criteria, one of which is date. I am comparing the records within a [showif] based on what events have past. All date formats are in mm/dd/yyyy format, and it works properly if the year is 2004. It does not display the records that are dated yesterday, or before (correctly). But it does not function with any xx/xx/2005 or later dated events. It only functions with dates between today and 12/31/2004. EDIT_DATE is the field holding the date. [search db=../ reservations.db&geEDIT_DATEdata=[date]&asEDIT_DATEsort=1&EDIT_DATEtype=d ate] ......... snip code ........... [showif [EDIT_DATE]<[date]] ....... displays the table row ....... [/showif] Thanks for any insight into this delimma Steve Braun sbraun1@twcny.rr.com ------------------------------------------------------------- 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: Date Sort question ( sbraun 2004)
  2. Re: Date Sort question ( Terry Wilson 2004)
  3. Re: Date Sort question ( sbraun 2004)
  4. Re: Date Sort question ( "Erol Guneri" 2004)
  5. Date Sort question ( sbraun 2004)
Hi, Thanks to all for the help with the rotating photo gallery, I'm still waiting for the client to confirm....meanwhile, I have to ask about sorting/comparing by date. I am viewing db contents of calendar reservation events in an html table, and I wish to sort by various criteria, one of which is date. I am comparing the records within a [showif] based on what events have past. All date formats are in mm/dd/yyyy format, and it works properly if the year is 2004. It does not display the records that are dated yesterday, or before (correctly). But it does not function with any xx/xx/2005 or later dated events. It only functions with dates between today and 12/31/2004. EDIT_DATE is the field holding the date. [search db=../ reservations.db&geEDIT_DATEdata=[date]&asEDIT_DATEsort=1&EDIT_DATEtype=d ate] ......... snip code ........... [showif [EDIT_DATE]<[date]] ....... displays the table row ....... [/showif] Thanks for any insight into this delimma Steve Braun sbraun1@twcny.rr.com ------------------------------------------------------------- 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/ sbraun

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:

For those of you not on the WebCatalog Beta... (1997) Img in goodpath (2001) Nested search index (2000) Claris HomePage messes up the code (1997) [SHOWIF]s and empty arguments (1997) Help! WebCat2 bug (Ben's input) (1997) Loop context to replace items (1998) WebCat2b13 Command Reference Doc error (1997) Multiple condition showif's (2004) Searching for words equal to A or equal to B (1999) Release of 2.01? (1997) [Sum] function? (1997) Searching multiple Databases (1997) Banner DNA (1997) [delete] problem (1997) Maximum characters in header? (1999) Q: old cart serial problem (2000) suffix mapping for NT? (1997) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) HTML Editors (1997)