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:
showif and cart (1997)
Separate SSL Server (1997)
StoreBuilder Shopping Cart (2000)
[WebDNA] WebDNA and Google Geo Tagging (2012)
WebDelivery downloads alias, not original ? (1997)
WebCat2 - many [carts] on one template page? (1997)
PCS Frames (1997)
Number searching/formats (1998)
[NT] ie 4.0 required (1997)
WebCatalog NT beta 18 problem (1997)
WCS Newbie question (1997)
WebCatalog and WebTen (1997)
Table sorting by selected category then others -SOLUTION (2004)
Cookies and webcat (1997)
WebCat2 several catalogs? (1997)
I guess I have a problem with commitment (2003)
BR (1997)
Re:Password Authentication - request example (1998)
Suppressing returns (2000)
My first ship table (1998)