searching by date range help needed
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 15668
interpreted = N
texte = I am trying to do a search where I display items posted older than 15 days and newer then 30 days.The code I am using to search for items that does not work is the followingThis gives me back things 15 days or newer[search db=message.db&uniqueIDsort=1&uniqueIDsdir=de&mdatetype=date&gemdatedatarq=[m ath date]{[date]}-15[/math]&eqlvldatarq=1]But when I tried the range search both with the type date in place and out. With the rq off the end of the mdatedate it did not work.Semi example with one the the things tried above[search db=message.db&uniqueIDsort=1&uniqueIDsdir=de&mdatetype=date&rnmdatedatarq=[m ath date]{[date]}-16[/math]+[math date]{[date]}-30[/math]&eqlvldatarq=1]I also played around with this[search db=message.db&uniqueIDsort=1&uniqueIDsdir=de&mdatetype=date&lemdatedatarq=[m ath date]{[date]}-15[/math]&gemdatedatarq=[math date]{[date]}-30[/math]&eqlvldatarq=1]And tried the allreqd=T in there.So somebody on this list must have done a date range search and can direct me to what concept I seem to be missing.TIA=============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com ===============================================
Associated Messages, from the most recent to the oldest:
I am trying to do a search where I display items posted older than 15 days and newer then 30 days.The code I am using to search for items that does not work is the followingThis gives me back things 15 days or newer[search db=message.db&uniqueIDsort=1&uniqueIDsdir=de&mdatetype=date&gemdatedatarq=[m ath date]{
[date]}-15[/math]&eqlvldatarq=1]But when I tried the range search both with the type date in place and out. With the rq off the end of the mdatedate it did not work.Semi example with one the the things tried above[search db=message.db&uniqueIDsort=1&uniqueIDsdir=de&mdatetype=date&rnmdatedatarq=[m ath date]{
[date]}-16[/math]+[math date]{
[date]}-30[/math]&eqlvldatarq=1]I also played around with this[search db=message.db&uniqueIDsort=1&uniqueIDsdir=de&mdatetype=date&lemdatedatarq=[m ath date]{
[date]}-15[/math]&gemdatedatarq=[math date]{
[date]}-30[/math]&eqlvldatarq=1]And tried the allreqd=T in there.So somebody on this list must have done a date range search and can direct me to what concept I seem to be missing.TIA=============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com ===============================================
grichter@panavise.com (Gary Richter)
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:
Waitfor file (2000)
More than one db with the same namn (was: WC2f3) (1997)
Date search - yes or no (1997)
THANKS (1997)
Country & Ship-to address & other fields ? (1997)
Clearly.home (1998)
Strange intermittent WebDNA problems (2008)
Mac: [ListFiles] bug alert (1997)
headers (2004)
Authenticate (1997)
TaxRate and ShipCost Problem (1998)
HELP!! problems with e-mail from WebCAT (1998)
Generating unique SKU from [cart] - Still Stumped... (1997)
IE-caching (1998)
Another IfThenElse question.. (2003)
refreshing IE with posted .tmpl (1997)
Shopping Cart Best Practices (2006)
Frames and WebCat (1997)
includes and cart numbers (1997)
Fun with dates (1997)