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:
WebDNA install on Tiger doesn't work ... (2005)
I give up!! (1997)
Support ?? (1997)
Help formatting search results w/ table (1997)
[WebDNA] tag [validcard] fails on webdna 7.0. Do I need the commerce edition? (2011)
Trouble with emailer (2000)
WebDNA Docs (2003)
Re[2]: ftp access on Macos X (2000)
Busy WebCatalog (2000)
Serving images from databases (1998)
Bug or syntax error on my part? (1997)
[format xs] freeze (1997)
Using [sendmail] for mass mailings (2001)
help with duplicate records posted (1998)
converchars in sendmail context.... (2004)
problems with 2 tags (1997)
WC2.0 Memory Requirements (1997)
[Sum] function? (1997)
Re[2]: Problems with WebCat (2000)
Help with Shipping Costs (1997)