Re: Searching (second post)

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23132
interpreted = N
texte = Embed this in your called page:[search db=databasename.db&nePRODUCTdata=[blank]&asPRODUCTsort=1&max=25] [founditems][containers] html ect.
[/founditems]>I would like to perform a search on a database and have results sorted and >displayed according to the following criteria. > >Database is tab delimited text file with between 500 and 600 products. >I have two groups of fields I am searching through. >The first group contains fields like Product Name, Manufacturer and >Category of Products. >The second group contains descriptions. >I want all the results from the first group displayed first. >Then the set of results from the second group minus any redundant results >displayed. >If the search produces more than some number of results, say 25, then only >the first 25 results come up and then there is a link to get the next 25. > >I believe it makes sense to do a search like this because a match in >Product name or manufacturer is probably what a user is looking for, but >it makes sense to also look in description fields for less obvious matchs. > >Is is possible to create some sort of temporary Database, that is smart >enough to destroy itself after its used up and that will not create >problems if two or more users perform searches at or near the same time? > >Or can this just be done with some complex search? Associated Messages, from the most recent to the oldest:

    
  1. Re: Searching (second post) (PCS Technical Support 1999)
  2. Re: Searching (second post) (The Mooseman 1999)
  3. Searching (second post) (Josh Tiger (by way of josh@pop-art.com) 1999)
Embed this in your called page:[search db=databasename.db&nePRODUCTdata=[blank]&asPRODUCTsort=1&max=25] [founditems][containers] html ect.
[/founditems]>I would like to perform a search on a database and have results sorted and >displayed according to the following criteria. > >Database is tab delimited text file with between 500 and 600 products. >I have two groups of fields I am searching through. >The first group contains fields like Product Name, Manufacturer and >Category of Products. >The second group contains descriptions. >I want all the results from the first group displayed first. >Then the set of results from the second group minus any redundant results >displayed. >If the search produces more than some number of results, say 25, then only >the first 25 results come up and then there is a link to get the next 25. > >I believe it makes sense to do a search like this because a match in >Product name or manufacturer is probably what a user is looking for, but >it makes sense to also look in description fields for less obvious matchs. > >Is is possible to create some sort of temporary Database, that is smart >enough to destroy itself after its used up and that will not create >problems if two or more users perform searches at or near the same time? > >Or can this just be done with some complex search? The Mooseman

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:

Why does this not work? (2002) File not found error message (1998) Running _every_ page through WebCat-error.html (1997) Newbie - Search question (1998) when is failing to [URL]ize values in a comparison risky? (1999) [WebDNA] remove html comments (2009) Emailer (1997) SetHeader (1997) [math date] with non-US date format (2000) Debugging (2005) [Announce]: Web server security and password protection (1997) Caching pages...again (2001) Setting expiration dates for cookies (2000) Re:Item options w/ price adjustment (1997) Setting up shop (1997) Vann's - nice new WebCatalog site (1998) OSX 10.1.1 (2001) RE: IIS4b2 and WebCatalog b19 (1997) [protect] on NT? (1997) Tables (2005)