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 the greatest 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:

    
  1. Re: Searching for the end (Brian Fries 1998)
  2. Re: Searching for the end (Gary Richter 1998)
  3. Re: Searching for the end (Martin Gertz Bech 1998)
  4. Re: Searching for the end (Kenneth Grome 1998)
  5. Re: Searching for the end (Martin Gertz Bech 1998)
  6. Re: Searching for the end (Dave MacLeay 1998)
  7. Re: Searching for the end (Martin Gertz Bech 1998)
  8. Re: Searching for the end (Kenneth Grome 1998)
  9. Re: Searching for the end (Dave MacLeay 1998)
  10. Searching for the end (Martin Gertz Bech 1998)
Martin -If I understand your goal correctly, you want the 25 records with the greatest 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)