Re: Date Sort question

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59472
interpreted = N
texte = Does it need to be geEDIT_DATEdatarq=[date]? Erol ----- Original Message ----- From: "sbraun" To: "WebDNA Talk" Sent: Thursday, September 23, 2004 12:43 PM Subject: Date Sort question > 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/ > > ------------------------------------------------------------- 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)
Does it need to be geEDIT_DATEdatarq=[date]? Erol ----- Original Message ----- From: "sbraun" To: "WebDNA Talk" Sent: Thursday, September 23, 2004 12:43 PM Subject: Date Sort question > 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/ > > ------------------------------------------------------------- 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/ "Erol Guneri"

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:

placement of ? (2000) emailer settings and control questions (1997) Showif, Hideif reverse logic ? (1997) Random (2000) Field validation problem (1999) shipcost (1997) Forcing price recalculation in shopping cart (1998) shipcost (1997) can WC render sites out? (1997) Robert Minor duplicate mail (1997) cart info (1998) Large Database Options? (1999) weening me off overwriting form variables. John Peacock? (2000) test (2000) Signal Raised Error (1997) Displaying search results in a new frameset (1997) [WebDNA] Mac OS X Server ("Maverick") - Not Authorized (2014) DB Field Name? (2000) Math with Time (1997) Release of 2.01? (1997)