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:

Secure server question (1997) [WebDNA] WebDNA Host needed urgently (2013) frames & carts (1997) mod_webcatalog2.so (2003) passing user info on each page (2000) Price and Formula.db (2002) Security (2002) Adding more than one item and QTY to cart (2000) Formvariable won't update (1999) WebCatalog not running after upgrade (2000) [WebDNA] Failed to aquire lock on database - Possible deadlock averted (2011) WebCat B13 Mac CGI -- Frames question (1997) Empty Shopping Carts? (1998) b12 cannot limit records returned and more. (1997) Has this happened to you? (was:Emailer Chokes on bad address) (1997) No Wanna Duppys (1998) Re[3]: 2nd WebCatalog2 Feature Request (1996) WebCat.acgi from /cgi-bin/? (1997) form data submission gets truncated (1997) Post size Limit? (1998)