Re: Date Range works

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15713
interpreted = N
texte = You're welcome.>Jay's idea to reverse the ranges works just peachy! > >This is using the range or rn below in front of the mdatedatarq > >This works > >[Search >db=message.db&uniqueIDsort=1&uniqueIDsdir=de&mdatetype=date&rnmdatedatarq=[mat >h date]{[date]}-20[/math]+[math date]{[date]}-10[/math]&eqlvldatarq=1] > >Reverse the 10 and the 20 and nada. Even tho I display in de order based >on a number I create, it appears the smaller number must be in front and >the larger number in the back. Dah...I should have paid more attention to >the zip code example in the online reference. Smaller number first, larger >number last, no matter what my sort order is. Maybe a note in the >online docs for others to see. > >Thanks Jay > > >=============================================== >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 >=============================================== John A. Hill, V.P. Marketing Pacific Coast Software eCommerce / Web Developer Tools http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Date Range works (John Hill 1997)
  2. Date Range works (grichter@panavise.com (Gary Richter) 1997)
You're welcome.>Jay's idea to reverse the ranges works just peachy! > >This is using the range or rn below in front of the mdatedatarq > >This works > >[Search >db=message.db&uniqueIDsort=1&uniqueIDsdir=de&mdatetype=date&rnmdatedatarq=[mat >h date]{[date]}-20[/math]+[math date]{[date]}-10[/math]&eqlvldatarq=1] > >Reverse the 10 and the 20 and nada. Even tho I display in de order based >on a number I create, it appears the smaller number must be in front and >the larger number in the back. Dah...I should have paid more attention to >the zip code example in the online reference. Smaller number first, larger >number last, no matter what my sort order is. Maybe a note in the >online docs for others to see. > >Thanks Jay > > >=============================================== >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 >=============================================== John A. Hill, V.P. Marketing Pacific Coast Software eCommerce / Web Developer Tools http://www.smithmicro.com John Hill

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:

[WebDNA] Feature requests - date format (2009) BUG?-.html extention not working. (2000) when is date system date or order date? (1997) WebCat2b12plugin - [search] is broken ... not! (1997) Apache processes (2003) Remove me from your list immeadiately (1998) Trouble with formula.db (1997) Frames and WebCat (1997) purchase.log file (1997) sorting problem for sku=0? (1998) Speed Optimization - Mac (1997) with Link i need to (1997) PCS Frames (1997) Some Questions (1997) sorting dates (1999) Long/Lat (2002) Re(6): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998) Document Contains No Data! (1997) Which version to buy? (2000) Occasional crashes with $remove (1997)