Re: Searching for the end

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 21507
interpreted = N
texte = >The exact thing i need to do is find the last 25 VURDERINGSNUMMER and sort>it by date in descending order, so the last comes first>But i can't get it to work :-{I think you *cannot* solve your problem until you create a field whose value is set at the time the record is created and whose value is larger than all the other values in the db.It's easy to use the [cart] tag for this task, because all you have to do is put fieldName=[cart] into your append context, and it will automatically create a unique value that's ALPHABETICALLY the largest value in the database (assuming you're not passing some other cart value to the page with the append context in it).Then you can do a search that retrieves all the records in the database (neSKUdatarq=[blank]) and limits the results to 25 records per founditems context (max=25) and sorts that field in descending order so the LAST 25 records will be the ones displayed (defieldNamesort=1).But right now, you don't have any field in your database that can be sorted in descending order and still retrieve the last 25 records. And any other sort you perform will result in having the records returned in a different order, not in reverse database order. So it seems you need to create a new field for the purpose of sorting in reverse-database order.It would be nice if PCS would consider making a new parameter that does this for us. We have rank=off to give us our results in database order --with no sorting at all -- but we have nothing to give us the results in reverse-database order.Perhaps a parameter like dbsort=reverse might be added to the WebDNA language, which would tell webcat to display the founditems in the OPPOSITE order from the way they appear in the db.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net Associated Messages, from the most recent to the oldest:

Re: Searching for the end (Brian Fries 1998)
Re: Searching for the end (Gary Richter 1998)
Re: Searching for the end (Martin Gertz Bech 1998)
Re: Searching for the end (Kenneth Grome 1998)
Re: Searching for the end (Martin Gertz Bech 1998)
Re: Searching for the end (Dave MacLeay 1998)
Re: Searching for the end (Martin Gertz Bech 1998)
Re: Searching for the end (Kenneth Grome 1998)
Re: Searching for the end (Dave MacLeay 1998)
Searching for the end (Martin Gertz Bech 1998)

>The exact thing i need to do is find the last 25 VURDERINGSNUMMER and sort>it by date in descending order, so the last comes first>But i can't get it to work :-{I think you *cannot* solve your problem until you create a field whose value is set at the time the record is created and whose value is larger than all the other values in the db.It's easy to use the [cart] tag for this task, because all you have to do is put fieldName=[cart] into your append context, and it will automatically create a unique value that's ALPHABETICALLY the largest value in the database (assuming you're not passing some other cart value to the page with the append context in it).Then you can do a search that retrieves all the records in the database (neSKUdatarq=[blank]) and limits the results to 25 records per founditems context (max=25) and sorts that field in descending order so the LAST 25 records will be the ones displayed (defieldNamesort=1).But right now, you don't have any field in your database that can be sorted in descending order and still retrieve the last 25 records. And any other sort you perform will result in having the records returned in a different order, not in reverse database order. So it seems you need to create a new field for the purpose of sorting in reverse-database order.It would be nice if PCS would consider making a new parameter that does this for us. We have rank=off to give us our results in database order --with no sorting at all -- but we have nothing to give us the results in reverse-database order.Perhaps a parameter like dbsort=reverse might be added to the WebDNA language, which would tell webcat to display the founditems in the OPPOSITE order from the way they appear in the db.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net Kenneth Grome

DOWNLOAD WEBDNA NOW!

Re: Searching for the end

1998

Top Articles:

Related Readings: