Re: Searching for the end
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21490
interpreted = N
texte = Well, aint it a problem that it will still find al the records but only display the last 25?What i mean is, aint it much slower, instead of lik having a context thet could give me a value of the last record?Maybe it would be an idea for pacific coast to implement a [gethigestvalue] into a furture version of webcatI think we all could use a tag like that, in MANY creative solutions/Martin>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:
Well, aint it a problem that it will still find al the records but only display the last 25?What i mean is, aint it much slower, instead of lik having a context thet could give me a value of the last record?Maybe it would be an idea for pacific coast to implement a [gethigestvalue] into a furture version of webcatI think we all could use a tag like that, in MANY creative solutions/Martin>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 --+
Martin Gertz Bech
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:
absolute paths for databases? (1997)
shared_POP and archiving your own mailing list (2003)
OT: Need some DVD advice (2006)
DB Size - MAX (2004)
Strange error (2000)
Protect tag for large groups? (1999)
Old Topic - [OT] - server speeds. (2002)
[WebDNA] ONLY the FIRST continuous run of numeric chars? (2008)
Running 2 two WebCatalog.acgi's (1996)
Magic [text] shows and then no show (2000)
OT: NT mac sharing (1998)
Extended [ConvertChars] (1997)
Text data with spaces in them... (1997)
WC on Mac OS X or Mac OS X Server 2.x (2001)
[protect admin] (1997)
Conveting Characters to Graphics (1997)
French Webcat User (2002)
[sendmail] from a post (2007)
problems with WebCat-Plugin (1997)
Sending htmlmail (2007)