Re: Date Sort question

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59487
interpreted = N
texte = >[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/ 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)
>[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/ Terry Wilson

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:

Multiple prices (1997) Frames and WebCat (1997) Re:quit command on NT (1997) Formating Tables w/[founditems] (1998) 2.0 Info (1997) redirect within the ErrorMessages.db (2003) RE: OK, here goes... (1997) problem: search crashes webstar (1997) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) Running 2 two WebCatalog.acgi's (1996) Re:listfiles-looking for slick solution (1997) WCS Newbie question (1997) Setting up shop (1997) Shipping Calculation Problem (1997) Multiple Users.db Possible? (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) can you take a look (2003) Before I Can Begin . . . (1998) Sizes/Colors Options (2006) Credit Card Gateways (2005)