Re: Searching for the end

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21494
interpreted = N
texte = Any search, whether it's displaying 1 match, 25, or all matches, has to search the entire database, so there's really no performance loss in doing max=25.If all you want to do is find the highest SKU value, you can do a search something like this: [Search db=my.db&neSKUdatarq=[blank]&deSKUsort=1&max=1][FoundItems][SKU][/FoundItems][/S earch]In my experience, it tends to be fairly quick.If you're going to use the value in a number of places and don't want to do the search several times, just store the value in a [math] or [text] variable.-Dave At 2:38 PM 12/3/98, Martin Gertz Bech wrote: >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 webcat > >I think we all could use a tag like that, in MANY creative solutions > >/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)
Any search, whether it's displaying 1 match, 25, or all matches, has to search the entire database, so there's really no performance loss in doing max=25.If all you want to do is find the highest SKU value, you can do a search something like this: [Search db=my.db&neSKUdatarq=[blank]&deSKUsort=1&max=1][founditems][SKU][/FoundItems][/S earch]In my experience, it tends to be fairly quick.If you're going to use the value in a number of places and don't want to do the search several times, just store the value in a [math] or [text] variable.-Dave At 2:38 PM 12/3/98, Martin Gertz Bech wrote: >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 webcat > >I think we all could use a tag like that, in MANY creative solutions > >/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:

trouble updating records in database (1998) WC2f3 (1997) Webcat2, WebCommerce, Mod 10 etc. (1997) 2.0 Info (1997) webdelivery.html and webna (1997) 4.0x on production server (2000) PSC recommends what date format yr 2000??? (1997) Closing databaes (2002) Laying an egg. (1998) WebCat b13 CGI -shownext- (1997) [WebDNA] Calculate Cube root (2012) WebDNA Writer Needed (1997) Problem (1997) Hosting WebDNA (2006) HELP WITH DATES (1997) WebTen and WebCat (1997) RequiredFields template (1997) international time (1997) [WebDNA] search by range of dates (2009) WebCat2.0 [format thousands .0f] no go (1997)