Re: Date Question
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 46343
interpreted = N
texte = 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:
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:
How do I find where my IP address is located (2000)
carriage returns in data (1997)
[WebDNA] Grep everything and replace with asterisks? (2010)
Test (2003)
splitting numbers in webDNA? (1997)
WebDNA Writer Needed (1997)
Re2: frames & carts (1997)
Forcing a NEWCART (1997)
Writing multiple data into one field (1998)
Seattle based Webcatters? (2000)
[WebDNA] AutoFill Drop Down Menu (2009)
totals (1997)
[shownext max (1997)
Satisfy Me ! was: Why can't support be satisfying topurchasers? (2000)
Fufillment e-mail? (1998)
Running 2 two WebCatalog.acgi's (1996)
More on the email templates (1997)
Sorting by highest number of matches unique to a field (2003)
I give up!! (1997)
[WebDNA] showif/sendmail question (2008)