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 Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Associated Messages, from the most recent to the oldest:
>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 Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Kenneth Grome
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:
Shipping charges based on dollar level (1997)
Attn iTools / WebCat users.... (2004)
referrer usage (1997)
special commerce fields (1997)
How did *you* learn Web Catalog? (2000)
Change to 5.0 per website licensing (2003)
Search Combining Problem (2004)
More Shopping Cart Questions/Problems (2000)
color (1999)
RE: Submitting ampersands in forms... (1998)
[WebDNA] Security best practice (2009)
WebDNA Hosting? (2003)
taxrate - off by 1 cent (1997)
OT: NT mac sharing (1998)
Q: writefile and uploads. (1998)
Date problems (1997)
Problems getting parameters passed into email. (1997)
RE: Can a database get stomped by simultaneous access? (1997)
Date Calulation (1997)
WebCat2 several catalogs? (1997)