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:

encryption seeds xing (1998) Fufillment e-mail? (1998) Off Topic: Frames Killer? (1998) Error Lob.db records error message not name (1997) The Guru Speaks-very long reply (1998) Can you identify the [body]? (1999) default value from Lookup (was Grant, please help me) (1997) WebCat2b12--[searchstring] bug (1997) WebCatalog 3 for Macintosh (1998) email preferences on NT (1997) trouble with [shownext] (2000) RE: New WebCatalog Version !!! (1997) Problem with Formulas.db (1998) Not really WebCat (1997) Cart doesn't interpret tag! (1997) Format of Required fields error message (1997) too many nested tags ... (1997) Using Cookie for client specific info? (1997) Pass a form (2003) synching databases on multiple servers (1997)