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. sfb On 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:

    
  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)
Thank you Terry, It was the curly brackets as you said. Working fine now. Many Hanx. sfb On 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)