Re: Date Question

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 46361
interpreted = N
texte = Jeff put your [duedate] right above the showif in the founditems loop.Post exactly one of the results to the list.Donovan >>>>| [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:> Sorry this did not work either. See my next post. > > Jeff > > >[SHOWIF [MATH]{[duedate]}<{[date]}[/MATH]=1] > > PAST DUE > >[/SHOWIF] > > > >-----Original Message----- > >From: Jeff Logan [mailto:jefftalk@insideout.com] > >Sent: Tuesday, December 17, 2002 10:09 AM > >To: WebDNA-Talk@talk.smithmicro.com > >Subject: Re: Date Question > > > >Tried it and it did not work. Any other ideas. Need me to post the full > >code? > > > >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 > >>>>| > > ------------------------------------------------------------------------ > ------------------------------------------------------------- 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)
Jeff put your [duedate] right above the showif in the founditems loop.Post exactly one of the results to the list.Donovan >>>>| [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:> Sorry this did not work either. See my next post. > > Jeff > > >[SHOWIF [math]{[duedate]}<{[date]}[/MATH]=1] > > PAST DUE > >[/SHOWIF] > > > >-----Original Message----- > >From: Jeff Logan [mailto:jefftalk@insideout.com] > >Sent: Tuesday, December 17, 2002 10:09 AM > >To: WebDNA-Talk@talk.smithmicro.com > >Subject: Re: Date Question > > > >Tried it and it did not work. Any other ideas. Need me to post the full > >code? > > > >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 > >>>>| > > ------------------------------------------------------------------------ > ------------------------------------------------------------- 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/ Donovan

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:

Using a database with a short url (2000) Running 2 two WebCatalog.acgi's (1996) changing banners on a page without refresh? (2000) Running 2 two WebCatalog.acgi's (1996) WebCatalog2 Feature Feedback (1996) Credit card processing - UK (1997) webmerch and serials - almost there (1997) New public beta available (1997) math with multiple [founditems] (1999) docs for WebCatalog2 (1997) PCS Frames (1997) Unix DB Permission Error (2002) Shopping Cart Problem (1998) Truncated Sendmail (1998) Post arguments problem mac? (1997) Ken's grep question about renaming files to lowercase (2003) RE: PDF (1999) [ot] Any One Want A WebDNA Billing Program? (2003) Re:Formulas.db / Quantity Discount problem (1998) RE: Checkboxes to add to cart... (1998)