Re: Date Sort question
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 59493
interpreted = N
texte = Thank you Terry,It was the curly brackets as you said.Working fine now.Many Hanx.sfbOn Friday, September 24, 2004, at 07:32 AM, Terry Wilson wrote:>> [showif [EDIT_DATE]<[date]] <<<---(BTW Shouldn't that be a greater >> than?)>> This is your problem. While you specify [EDIT_DATE] as type=date in > the search, the showif is its own entity and doesn't know anything > about your search parameters. You need to [math] dates in order to get > them to compare properly. Math converts the dates into numbers (days > since the beginning of time). Use curly brackets around the dates:>> [showif [math]{[EDIT_DATE]}[/math]<[math]{[date]}[/math]]>> Terry>>>> [search >> db=../ >> reservations.db&geEDIT_DATEdata=[date]&asEDIT_DATEsort=1&EDIT_DATEtype >> =date]>>>> ........ snip code ...........>> [showif [EDIT_DATE]<[date]]>> ...... displays the table row .......>> [/showif]>>> -------------------------------------------------------------> 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:
Thank you Terry,It was the curly brackets as you said.Working fine now.Many Hanx.sfbOn Friday, September 24, 2004, at 07:32 AM, Terry Wilson wrote:>> [showif [EDIT_DATE]<[date]] <<<---(BTW Shouldn't that be a greater >> than?)>> This is your problem. While you specify [EDIT_DATE] as type=date in > the search, the showif is its own entity and doesn't know anything > about your search parameters. You need to [math] dates in order to get > them to compare properly. Math converts the dates into numbers (days > since the beginning of time). Use curly brackets around the dates:>> [showif [math]{[EDIT_DATE]}[/math]<[math]{[date]}[/math]]>> Terry>>>> [search >> db=../ >> reservations.db&geEDIT_DATEdata=[date]&asEDIT_DATEsort=1&EDIT_DATEtype >> =date]>>>> ........ snip code ...........>> [showif [EDIT_DATE]<[date]]>> ...... displays the table row .......>> [/showif]>>> -------------------------------------------------------------> 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/
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:
SERIAL NUMBER PROBLEM *AGAIN*!!! (1998)
Error - Search / Showif (2000)
URL for Discussion Archive (1997)
Thanks Grant (1997)
Execute Applescript (1997)
[WebDNA] Databases not staying open (2010)
[format] (1998)
possible, WebCat2.0 and checkboxes-restated (1997)
Serious bug writing to a database ... (2002)
[append] vs. [appendfile] delta + question? (1997)
Dealer locator (1998)
URL for Discussion Archive (1997)
A question on sub-categories (1997)
Trouble Searching (1999)
Multiple prices (1997)
RE: [WebDNA] Latest Windows Version (2010)
Help needed! (1998)
Interpreting WebDNA tags (2004)
creating an email message (1998)
Typhoon and Netpresenz? (1999)