Re: Search Philosophy
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39372
interpreted = N
texte = Donovan Brooke wrote: > > how would this be done??? > 1)add field to the db [or are you talking a different .db?]It depends on your database design. It would probably be faster to have a seperate database with SKU, KEYWORDS as the only fields. But if your database is relatively small (both in # of fields and content of fields) you can just add a new field.> 2)[replace] the value of the uppercase field with the converted contents > of original field???When an item is added to the main database, process the record and append or update the Keywords.db entry.> 3)[lookup] to the uppercase field.Bingo, then use [search] to locate just that record's information for display. OR, if you have < 5-6 fields to return, use [lookup]'s on the main database ([search] is that much slower than [lookup]).> > how would you not look for spaces? just convert the > original field contents to no spaces in the uppercase field?I would store all of the keywords seperated by a delimiter which did not exist in the data (underscore or pipe being popular choices). Then always wrap the search term in the same delimiters if you want to eliminate substring matches (eg. _ANT_ won't match _ANTEATER_). You can even do a starts with search (e.g. _ANT will match both _ANT_ and _ANTEATER_).> > lastly, what is TMTOWTDI?? ;-)http://www.tuxedo.org/~esr/jargon/html/entry/TMTOWTDI.htmlJohn-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Donovan Brooke wrote: > > how would this be done??? > 1)add field to the db [or are you talking a different .db?]It depends on your database design. It would probably be faster to have a seperate database with SKU, KEYWORDS as the only fields. But if your database is relatively small (both in # of fields and content of fields) you can just add a new field.> 2)[replace] the value of the uppercase field with the converted contents > of original field???When an item is added to the main database, process the record and append or update the Keywords.db entry.> 3)[lookup] to the uppercase field.Bingo, then use [search] to locate just that record's information for display. OR, if you have < 5-6 fields to return, use [lookup]'s on the main database ([search] is that much slower than [lookup]).> > how would you not look for spaces? just convert the > original field contents to no spaces in the uppercase field?I would store all of the keywords seperated by a delimiter which did not exist in the data (underscore or pipe being popular choices). Then always wrap the search term in the same delimiters if you want to eliminate substring matches (eg. _ANT_ won't match _ANTEATER_). You can even do a starts with search (e.g. _ANT will match both _ANT_ and _ANTEATER_).> > lastly, what is TMTOWTDI?? ;-)http://www.tuxedo.org/~esr/jargon/html/entry/TMTOWTDI.htmlJohn-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
John Peacock
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:
triggers.db (1999)
Processing stops (2006)
Unusual characters in the db ... (2002)
required fields??? (2000)
shipping costs (1997)
redirect not passing vars (2004)
4.5 -> 6.0 Upgrade (2005)
Date sorting (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Database Locking?!? (2000)
[referrer] tag (1997)
Running 2 two WebCatalog.acgi's (1996)
WebCat2 beta 11 - new prefs ... (1997)
Log-in Scheme (2003)
Input appreciated (2000)
Email and name capture (1999)
WebCatalog Q & A pages (1997)
Online reference (1997)
IIS4b2 and WebCatalog b19 (1997)
AOL and [referrer] (2001)