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:
Supressing Error Messages (1998)
blank fields (1999)
Using [Include] Context (1999)
WebDNA 4.5.1 Now Available (2003)
Problem: 3.0 doesn't update carts (1997)
all records returned. (1997)
Graphical display of sales volume (2003)
Warning: Mac OS X 10.2.4 Update Overwrites Apache's (2003)
Only charge card when product shipped ? (1997)
ListFiles Sorting (2000)
ANother SHOWIF problem (1997)
Protect vs Authenicate (1997)
faulure to encrypt (or maybe decrypt) (1999)
[random] only for 1-100??? (1997)
textarea data entry and display (2000)
Question re: FlushDatabases (1997)
OFF-TOPIC: No messages since Saturday (1998)
Problem 2: Prefs file... (1997)
Sorry - the list went haywire... (1998)
Ampersand in XHTML Code - Not Valid (2005)