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:
Removing [showif] makes a big difference in speed (1997)
'does not contain' operator needed ... (1997)
WebMerchant 1.6 and SHTML (1997)
OT: Poll Results (2002)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
accountnum using [listwords] (2001)
unitshipcost vs shipcosts (1997)
[ListFiles] from a remote host (2003)
Pithy questions on webcommerce & siteedit (1997)
RequiredFields template (1997)
[WebDNA] a major shift in strategy? (2008)
RE: Migrating to NT (1997)
Format of Required fields error message (1997)
Am I going senile? (Price recalc based on quantity) (1997)
RE: CloseDatabase (1997)
[OT] FTP client (2003)
BUG in [showif] using ^ (contains) (1997)
There's a bug in the math context ... (1997)
Date Formats (1997)
[showif] / [hideif] (1997)