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:

Ok here is a question? (1997) How true is this? (1999) Not reading code (1997) all records returned. (1997) WebCatalog seems to choke on large (2meg) html files. (1998) Error Msg (1998) Help formatting search results w/ table (1997) creating writefile data from a nested search (1997) Fun with Dates - finally resolved but.... (1997) Cart questions (1997) Release of 2.01? (1997) WebCat2b13MacPlugIn - [include] (1997) TCP Connect (1999) [WebDNA] parsing xml (2010) unable to launch acgi in WebCat (1997) TaxTotal Problem (1997) Formatting ModDate (2000) Help name our technology! (1997) problem with applets embedded in tpl files (1997) can we get string variables? (1998)