Re: Date Question
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 46351
interpreted = N
texte = >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 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:
>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 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:
change the number format (1997)
[WebDNA] A new popuated field to a DB with 700.000 records (2009)
PIXO support (1997)
Keep away (1997)
Limits (2000)
Search Trouble (2002)
RE: Checkboxes to add to cart... (1998)
download database (2000)
StartAT and shownext (2000)
[delete] problem (1997)
New to WebCat, Help. (1998)
multiple product databases (1997)
Re:What file? (1997)
Checkbox question (1997)
Table sorting by selected category then others -SOLUTION (2004)
ShowNext and random sort (1998)
Tax on Shipping question (1998)
Problem (1997)
Random question (1998)
[WebDNA] Install/config issue: WebDNA-MacTel-6.2>OS X Server (2009)