Re: Searching for the end

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21481
interpreted = N
texte = If you're sorting by SKU, just add &deSKUsort=1&SKUtype=num&max=25 to your search context.If you need to display the last 25 in ascending order, you'd probably need to do two searches: the first one would just find the total number of matching records, and then the second, nested search context could use &startat=[math][NumFound]-25[/math] and whatever sort order you desire...-Dave At 6:13 AM 12/2/98, Martin Gertz Bech wrote: >I have a db file with a SKU number for each record, > >This files is getting bigger and bigger, and now i want to make a template >that shows only the last 25 > >but how can i do that, when i dont know the value of the current highest >SKU??? > >any ideas, anybody? > > >/Martin o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+ 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)
If you're sorting by SKU, just add &deSKUsort=1&SKUtype=num&max=25 to your search context.If you need to display the last 25 in ascending order, you'd probably need to do two searches: the first one would just find the total number of matching records, and then the second, nested search context could use &startat=[math][NumFound]-25[/math] and whatever sort order you desire...-Dave At 6:13 AM 12/2/98, Martin Gertz Bech wrote: >I have a db file with a SKU number for each record, > >This files is getting bigger and bigger, and now i want to make a template >that shows only the last 25 > >but how can i do that, when i dont know the value of the current highest >SKU??? > >any ideas, anybody? > > >/Martin o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+ Dave MacLeay

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:

and vs or vs not (1998) RE: Credit Card Checksum (1997) OT: Forcing a header when printing web pages (2002) Problems w/ heavy use of cart header fields? (1998) Problem saving images in Explorer (2001) Questions To Answer (1997) WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997) Showif Context combined with Search (1997) [WriteFile] problems (1997) [TIME] not working (2007) f2 download problems (1997) [searchString] (1997) Use of Back and Reload Buttons on ShoppingCart page? (1997) get vs post - Back to Basics. (2001) Webcat2, WebCommerce, Mod 10 etc. (1997) WC2.0 Memory Requirements (1997) DDE feature in webcat (1998) emailer w/F2 (1997) Problems adding stuff to the shopping cart. (1997) Fun with dates (1997)