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 delimmaSteve Braunsbraun1@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:
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 delimmaSteve Braunsbraun1@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)