Re: Dates - Search and Sorting
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23035
interpreted = N
texte = Speaking of date sorting issues, I am having trouble myself. I am trying toset up a template so that it only displays an article between a StartDateand EndDate.My search is:[searchdb=articles.db&eqSectiondata=[Section]>EndDatedata=[date]&EndDatetype=date<StartDatedata=[date]&StartDatesort=1&StartDatesdir=as&StartDatetype=date]When I insert [date] in a template, the result is formatted like this:01/27/1999, which I assume means that's how the preferences are set.The dates in the database are formatted the same way. Yet I must be doingsomething wrong because it doesn't matter what dates I put in the database,all articles with matching [Section] show up in the search.What am I doing wrong?Mike
Associated Messages, from the most recent to the oldest:
Speaking of date sorting issues, I am having trouble myself. I am trying toset up a template so that it only displays an article between a StartDateand EndDate.My search is:[searchdb=articles.db&eqSectiondata=[Section]>EndDatedata=
[date]&EndDatetype=date<StartDatedata=
[date]&StartDatesort=1&StartDatesdir=as&StartDatetype=date]When I insert
[date] in a template, the result is formatted like this:01/27/1999, which I assume means that's how the preferences are set.The dates in the database are formatted the same way. Yet I must be doingsomething wrong because it doesn't matter what dates I put in the database,all articles with matching [Section] show up in the search.What am I doing wrong?Mike
Mike_Davis
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:
Is Web Merchant Necessary? (2000)
Exclude by date - multiple (1997)
[Sum] function? (1997)
WC1.6 to WC2 date formatting (1997)
Three new problems, maybe a fourth (1997)
Sending emails (went[ot] ) (2002)
question: webmerchant connection (1997)
Newbie problem blah blah blah (1997)
What generates Problem With Your Order email? (2000)
please anybody help (2005)
my price won't move (1997)
using listfiles to build a database? (2000)
Navigator 4.01 (1997)
Bug? (1997)
syntax question, not in online refernce (1997)
re: Large databases in WebCat (1997)
For those of you not on the WebCatalog Beta... (1997)
#$%@! formulas (1998)
Append command (2000)
[include ...] behavior (1997)