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:
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)