Re: Searching for the end
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21530
interpreted = N
texte = Martin -If I understand your goal correctly, you want the 25 records with thegreatest VURDERINGSNUMMER value, sorted in descending date order?If this is correct, the following should do it...[!] Find the 25th from the greatest VURDERINGSNUMMER value [/!][search db=realdb.db&neVURDERINGSNUMMERdata=[blank][!] [/!]&deVURDERINGSNUMMERsort=1&VURDERINGSNUMMERtype=num&max=25] [founditems] [math show=F]mVURDERINGSNUMMER=[VURDERINGSNUMMER][/math] [/founditems][/search][!] Sort the last 25 records in descending date order [/!][search db=realdb.db&geVURDERINGSNUMMERdata=[math]mVURDERINGSNUMMER[/math][!] [/!]&VURDERINGSNUMMERtype=num &deVURDERINGSDATOsort=2[!] [/!]&VURDERINGSDATOtype=date_dmy]>The problem is>>I cant be sure that the tab file i get from the customer has the records in>the right way, even not in the same way every time, i dont think that i>would be able to use the [cart] tag for that>>SHoudn't there be a way to do it, when i do have a unique field called>VURDERINGSNUMMER which is always thetype NUM and then afterwards do a sort>on my DATE like deVURDERINGSDATOsort&deVURDERINGSDATOtype=date_dmy>>then the hole string should be>>[search>db=realdb.db&neVURDERINGSNUMMERdata=[blank]&deVURDERINGSNUMMERsort=1&VURDERINGS>N>UMMERtype=num&deVURDERINGSDATOsort=2&VURDERINGSDATOtype=date_dmy&max=25]>>>>That should be it, shouldn't it???>>>(it came to me while writing this mail, so its not testet yet)>/Martin>- Brian(p.s. sorry if my message is late, I'm a digest subscriber)
Associated Messages, from the most recent to the oldest:
Martin -If I understand your goal correctly, you want the 25 records with thegreatest VURDERINGSNUMMER value, sorted in descending date order?If this is correct, the following should do it...
[!] Find the 25th from the greatest VURDERINGSNUMMER value [/!][search db=realdb.db&neVURDERINGSNUMMERdata=[blank]
[!] [/!]&deVURDERINGSNUMMERsort=1&VURDERINGSNUMMERtype=num&max=25]
[founditems] [math show=F]mVURDERINGSNUMMER=[VURDERINGSNUMMER][/math] [/founditems][/search]
[!] Sort the last 25 records in descending date order [/!][search db=realdb.db&geVURDERINGSNUMMERdata=
[math]mVURDERINGSNUMMER[/math]
[!] [/!]&VURDERINGSNUMMERtype=num &deVURDERINGSDATOsort=2
[!] [/!]&VURDERINGSDATOtype=date_dmy]>The problem is>>I cant be sure that the tab file i get from the customer has the records in>the right way, even not in the same way every time, i dont think that i>would be able to use the
[cart] tag for that>>SHoudn't there be a way to do it, when i do have a unique field called>VURDERINGSNUMMER which is always thetype NUM and then afterwards do a sort>on my DATE like deVURDERINGSDATOsort&deVURDERINGSDATOtype=date_dmy>>then the hole string should be>>[search>db=realdb.db&neVURDERINGSNUMMERdata=[blank]&deVURDERINGSNUMMERsort=1&VURDERINGS>N>UMMERtype=num&deVURDERINGSDATOsort=2&VURDERINGSDATOtype=date_dmy&max=25]>>>>That should be it, shouldn't it???>>>(it came to me while writing this mail, so its not testet yet)>/Martin>- Brian(p.s. sorry if my message is late, I'm a digest subscriber)
Brian Fries
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:
2.0 Info (1997)
formvariables not passing (2000)
RAW=T..Strange behaviour (2000)
[moveFile] Question (1999)
Database Options (1997)
Mass-mailer options - any suggestions ? (2005)
IE, Layers, and Select (2002)
WebCat2b15MacPlugin - [protect] (1997)
Filemaker Pro Template for Orders (1999)
[OT] Am I an Idiot? (2004)
This list needs a digest: rant, rave... (1997)
How about the Pascal approach? (2004)
[WebDNA] WebDNA slow processing (2011)
I give up!! (1997)
Stumped on ShowNext -using variables (1997)
Date problems-more (1997)
duplicate cart number (2002)
Problem with ShoppingCart.tpl refresh (2000)
Text limits in NT version? (1997)
Nested tags count question (1997)