Searching (second post)

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23131
interpreted = N
texte = 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)
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? Josh Tiger (by way of josh@pop-art.com)

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:

Constructive criticism (2000) PCS Frames (1997) no [search] with NT (1997) [WebDNA] Best Linux distro for a dedicated webdna server? (2011) Blocking form spam (2006) Text data with spaces in them... (1997) Can't find templaes (1997) Newbie needs advice to learn to use WebDNA (2003) Limitations on fields? Server is crashing (1997) [BULK] [WebDNA] [BULK] WebDNA 7 - Ready or Not ?? I'm not sure... (2011) Netscape Communicator 4 chops off URLs (was No Data) (1997) Cookie still not working (1999) mass mailing (1998) [SHOWIF AND/OR] (1997) emailer (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) [OT] JS Libraries (2007) Hiding HTML and page breaks (1997) Cannot calculate prices (1997) WebCat4.01 and WebMerchant Crashing (2000)