Re: Searching (second post)

This WebDNA talk-list message is from

1999

It keeps the original formatting. numero = 23134
interpreted = N
texte = >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.The standard ordering for found items is to put 'better' matches at the topof the list -- which means that any records that match in *both* groups aredisplayed first, followed by items with fewer hits. Basically, multiple'hits' in a single record cause that record to bubble to the top of thelist. This is similar to how the search engines do it. This does notsound like your criteria, though.>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.This is handled by [ShowNext], with max=25 in the search.>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?Yes, you could write a database (using [WriteFile]) named [cart].db, andthen at the end of the template you could do [closedatabase db=[cart].db]and then [deletefile file=[cart].db]. This might work faster than youthink. Tp remove duplicates, you would use the summary feature:fieldnameSUMM=TTechnical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: Searching (second post) (PCS Technical Support 1999)
Re: Searching (second post) (The Mooseman 1999)
Searching (second post) (Josh Tiger (by way of josh@pop-art.com) 1999)

>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.The standard ordering for found items is to put 'better' matches at the topof the list -- which means that any records that match in *both* groups aredisplayed first, followed by items with fewer hits. Basically, multiple'hits' in a single record cause that record to bubble to the top of thelist. This is similar to how the search engines do it. This does notsound like your criteria, though.>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.This is handled by [shownext], with max=25 in the search.>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?Yes, you could write a database (using [writefile]) named [cart].db, andthen at the end of the template you could do [closedatabase db=[cart].db]and then [deletefile file=[cart].db]. This might work faster than youthink. Tp remove duplicates, you would use the summary feature:fieldnameSUMM=TTechnical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ PCS Technical Support

DOWNLOAD WEBDNA NOW!

Re: Searching (second post)

1999

Top Articles:

Related Readings: