Date Range works
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 15710
interpreted = N
texte = Jay's idea to reverse the ranges works just peachy!This is using the range or rn below in front of the mdatedatarqThis 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 ===============================================
Associated Messages, from the most recent to the oldest:
Jay's idea to reverse the ranges works just peachy!This is using the range or rn below in front of the mdatedatarqThis 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 ===============================================
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:
cart number tracking (1998)
Cookies and webcat (1997)
[SameAsShipping] (2005)
[include ...] behavior (1997)
Sandbox DB permissions (2005)
Forms & Tables (1998)
Re:FYI: Error message (1996)
Progress !! WAS: Trouble with formula.db (1997)
PIXO Support (1997)
Determining position (2000)
acrobat -> wc (1998)
Help! WebCat2 bug (1997)
Weird bug, or is there something amiss? (1997)
Banners and sort of random display (1997)
[WriteFile] problems (1997)
Limiting user access to .tmpl files (1997)
orders with blanks or [xxx] literal text (2000)
Server Error Question [bug?] (2004)
'page impression' techniques for banner ads (1999)
Listfiles on network with NT (2000)