Re: Date Question
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 46354
interpreted = N
texte = Tried it and it did not work. Any other ideas. Need me to post the full code?Jeff>Have you tried John's suggestion with the curly brackets?>[showif {[duedate]}<{[date]}] PAST DUE -> [/showif]>>On Tue, 17 Dec 2002 09:48:44 -0800> Jeff Logan
wrote:>>>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/>>------------------------------------------------------------>http://www.StrongGraphicDesign.com>(208) 319-0137 | Toll-free p/f 877-561-1656>------------------------------------------------------------>>------------------------------------------------------------->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 SolutionsWeb, Marketing and Print DesignToll Free: 1-800-500-8401Phone: 360.683.5774 Fax: 360.683.5857Email: mailto:jeff@insideout.com229 South Sequim Ave, Sequim, WA 98382http://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:
Tried it and it did not work. Any other ideas. Need me to post the full code?Jeff>Have you tried John's suggestion with the curly brackets?>[showif {[duedate]}<{[date]}] PAST DUE -> [/showif]>>On Tue, 17 Dec 2002 09:48:44 -0800> Jeff Logan wrote:>>>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/>>------------------------------------------------------------>http://www.StrongGraphicDesign.com>(208) 319-0137 | Toll-free p/f 877-561-1656>------------------------------------------------------------>>------------------------------------------------------------->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 SolutionsWeb, Marketing and Print DesignToll Free: 1-800-500-8401Phone: 360.683.5774 Fax: 360.683.5857Email: mailto:jeff@insideout.com229 South Sequim Ave, Sequim, WA 98382http://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:
TCPConnect Help (2003)
Calculating multiple shipping... (1997)
Date Calulation (1997)
Sorting error (1997)
[WebDNA] sort parameters in search (2015)
[OT] Site test... (2003)
Fields font size (2003)
New reserved words for [tags] (2000)
Template transformed itself into a database? (1998)
So what ya working on? (or have you completed?) (2004)
[WebDNA] Retrieving a PDF from an email (2008)
[WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (2020)
I'm having trouble using [url][interpret][math] together in lookup (1997)
[WebDNA] CMS in WEBDNA (2009)
syntax question, not in online refernce (1997)
WCS Newbie question (1997)
[WebDNA] Urgent issues - WebDNA 6.2 under Ubuntu 10.04 (2015)
Sorting by date (1997)
[OT] Need help writing a proposal (2004)
synching databases on multiple servers (1997)