Re: Date Question

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 46351
interpreted = N
texte = >Not to point out the obvious, but since the font color is white for the >output from the showif, is your background perhaps white also? > >Just thought I'd throw that in there...I miss the obvious all the time, not >saying you do. >Background is gray.Jeff > >| Here is the full code with a search and just what I am having a >| problem with. [duedate] is a variable in the database that compares >| against todays date to show if a project is past due or not. >| >| Jeff Logan >| >| ---- >| >| [text show=f&secure=f]sort1=duedate[/text] >| [text show=f&secure=f]sort2=priority[/text] >| [text show=f&secure=f]showonly=all[/text] >| >| >| [search >| db=database.db&geskudata=0&as[sort1]sort=1&as[sort2]sort=2&asstatussor >| t=3[hideif >| [url][showonly][/url]=all]&eqprojecttypedatarq=[url][showonly][/url][/ >| hideif]&duedatetype=date&prioritytype=num] >| [founditems] >| >| [showif [duedate]<[date]]PAST DUE -> >| [/showif] >| >| >| [/founditems] >| [/search] >| >| >| >| >| >Jeff Logan wrote: >| >> I have my search string current it is just in the show if part. >| >> >| >> [showif [duedate]<[date]] PAST DUE -> [/showif] >| >> The show if say's yes to this if the date is in 2003. >| >> >| > >| >Well, you could try this instead: >| > >| >[showif {[duedate]}<{[date]}] PAST DUE -> [/showif] >| > >| >which will compare as numbers. You aren't inside an orderfile >| >contaxt are you (since in that case [date] is the Order date not the >| >Current date)? >| > >| >John >| > >| >-- >| >John Peacock >| >Director of Information Research and Technology >| >Rowman & Littlefield Publishing Group >| >4720 Boston Way >| >Lanham, MD 20706 >| >301-459-3366 x.5010 >| >fax 301-429-5747 > >------------------------------------------------------------- >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/ Personal service is #1 priority to us.------------------------------------------------ InsideOut Marketing and Web Solutions Web, Marketing and Print Design Toll Free: 1-800-500-8401 Phone: 360.683.5774 Fax: 360.683.5857 Email: mailto:jeff@insideout.com 229 South Sequim Ave, Sequim, WA 98382 http://www.insideout.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: [WebDNA] Quick Date Question (Govinda 2008)
  2. Re: [WebDNA] Quick Date Question (Govinda 2008)
  3. Re: [WebDNA] Quick Date Question (Steve Craig 2008)
  4. Re: [WebDNA] Quick Date Question (Gil Poulsen 2008)
  5. [WebDNA] Quick Date Question (Steve Craig 2008)
  6. Re: Silly date question ( Donovan Brooke 2006)
  7. Re: Silly date question ( Donovan Brooke 2006)
  8. Re: Silly date question ( Steve Craig 2006)
  9. Re: Silly date question ( Steve Craig 2006)
  10. Re: Silly date question ( Donovan Brooke 2006)
  11. Re: Silly date question ( Gary Krockover 2006)
  12. Re: Silly date question ( Donovan Brooke 2006)
  13. Silly date question ( Steve Craig 2006)
  14. Re: Date question ( Donovan Brooke 2003)
  15. Re: Date question ( John Peacock 2003)
  16. Re: Date question ( Donovan Brooke 2003)
  17. Re: Date question ( Donovan Brooke 2003)
  18. Re: Date question ( Alex McCombie 2003)
  19. Re: Date question ( andy mowrey 2003)
  20. Re: Date question ( John Hill 2003)
  21. Date question ( andy mowrey 2003)
  22. Re: Date Question (Dan Strong 2002)
  23. Re: Date Question (Gary Krockover 2002)
  24. Re: Date Question (Dan Strong 2002)
  25. Re: Date Question (Kenneth Grome 2002)
  26. Re: Date Question (Jeff Logan 2002)
  27. Re: Date Question (Donovan 2002)
  28. Re: Date Question (Donovan 2002)
  29. Re: Date Question (Jeff Logan 2002)
  30. Re: Date Question (Chris List Recipient 2002)
  31. Re: Date Question (Jeff Logan 2002)
  32. Re: Date Question (Dan Strong 2002)
  33. Re: Date Question (Jeff Logan 2002)
  34. Re: Date Question (Gary Krockover 2002)
  35. Re: Date Question (Jeff Logan 2002)
  36. Re: Date Question (John Peacock 2002)
  37. Re: Date Question (Dan Strong 2002)
  38. Re: Date Question (Jeff Logan 2002)
  39. Re: Date Question (Dan Strong 2002)
  40. Date Question (Jeff Logan 2002)
>Not to point out the obvious, but since the font color is white for the >output from the showif, is your background perhaps white also? > >Just thought I'd throw that in there...I miss the obvious all the time, not >saying you do. >Background is gray.Jeff > >| Here is the full code with a search and just what I am having a >| problem with. [duedate] is a variable in the database that compares >| against todays date to show if a project is past due or not. >| >| Jeff Logan >| >| ---- >| >| [text show=f&secure=f]sort1=duedate[/text] >| [text show=f&secure=f]sort2=priority[/text] >| [text show=f&secure=f]showonly=all[/text] >| >| >| [search >| db=database.db&geskudata=0&as[sort1]sort=1&as[sort2]sort=2&asstatussor >| t=3[hideif >| [url][showonly][/url]=all]&eqprojecttypedatarq=[url][showonly][/url][/ >| hideif]&duedatetype=date&prioritytype=num] >| [founditems] >| >| [showif [duedate]<[date]]PAST DUE -> >| [/showif] >| >| >| [/founditems] >| [/search] >| >| >| >| >| >Jeff Logan wrote: >| >> I have my search string current it is just in the show if part. >| >> >| >> [showif [duedate]<[date]] PAST DUE -> [/showif] >| >> The show if say's yes to this if the date is in 2003. >| >> >| > >| >Well, you could try this instead: >| > >| >[showif {[duedate]}<{[date]}] PAST DUE -> [/showif] >| > >| >which will compare as numbers. You aren't inside an orderfile >| >contaxt are you (since in that case [date] is the Order date not the >| >Current date)? >| > >| >John >| > >| >-- >| >John Peacock >| >Director of Information Research and Technology >| >Rowman & Littlefield Publishing Group >| >4720 Boston Way >| >Lanham, MD 20706 >| >301-459-3366 x.5010 >| >fax 301-429-5747 > >------------------------------------------------------------- >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/ Personal service is #1 priority to us.------------------------------------------------ InsideOut Marketing and Web Solutions Web, Marketing and Print Design Toll Free: 1-800-500-8401 Phone: 360.683.5774 Fax: 360.683.5857 Email: mailto:jeff@insideout.com 229 South Sequim Ave, Sequim, WA 98382 http://www.insideout.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/ Jeff Logan

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:

inconsistencies (1999) [showif]/[hideif] question (1997) WebCatalog 2.0 b 15 mac (1997) Re:quit command on NT (1997) I forgot (1998) followup to ws3 vs ws2.1 speed (1998) Is there a way to just get to the last record in the database? (1997) WebCat2 several catalogs? (1997) Banners and sort of random display (1997) WebMerchant and PCAuthorize (1998) Hideif not working? (2001) raw=T is broken in [include] (1997) wrong input values? (1997) no global [username] or [password] displayed ... (1997) Stopping bad HTML propagation ? (1997) European dates (1998) [WebDNA] Sandbox Triggers (2008) Nested tags count question (1997) [format xs] freeze (1997) WebCatalog stalls (1998)