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 PMSubject: 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:
Does it need to be geEDIT_DATEdatarq=[date]?Erol----- Original Message -----From: "sbraun" To: "WebDNA Talk" Sent: Thursday, September 23, 2004 12:43 PMSubject: 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:
Erotic Sites (1997)
Vann's - nice new WebCatalog site (1998)
WebCatalog2 Feature Feedback (1996)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
Uploading very large image files (2003)
Hiding HTML and page breaks (1997)
Summing fields (1997)
Sorting (2000)
Help! WebCat2 bug (1997)
SiteEdit NewFile.html ? (1997)
Tab Charactor (1997)
WebCat2 - [format thousands] (1997)
9 digit zip (2002)
Help! WebCat2 bug (1997)
[referrer] -truncates at & (1998)
Close Databases Crash? (1998)
Emailer (WebCat2) (1997)
Web*SSL and WebCatalog (1997)
Possible Bug in 2.0b15.acgi (1997)
Help name our technology! I found it (1997)