Re: Word search
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13634
interpreted = N
texte = At 2:50 PM -0800 9/26/97, Grant Hulbert is rumored to have typed:> >What I mean is this: If I do a search on my database for Myst (like the> >game), it returns entries with the word Myst but it also returns entries> >with words like mystery. I'd like it to return *just* the Myst records.>> Yes, you can: looking in the online docs under Searching/Word Breaks I>see that if you set fieldnameWORD=ww, then it looks for whole word matches.I can't believe that I never noticed that section before. Thanks for yourvery precise help.> >but webcat crashes> >my server if I do a search for a single letter, like X (which is the name> >of one of our products).>> That shouldn't happen, so should be considered a bug. Do you have enough>memory allocated to handle a huge amount of returned text when someone>looks for a single letter? Do you have the maximum number of returned>records set pretty low in your preferences?I have the maximum number prefs set to 500, and about 25 MB of RAMallocated to WebStar.MichaelMichael Winston *By Phone!: (503)/652/8815 x341Internet Coordinator *By e-mail!: michaelw@dhorse.comDark Horse Comics, Inc. *By web!: http://www.dhorse.com/
Associated Messages, from the most recent to the oldest:
At 2:50 PM -0800 9/26/97, Grant Hulbert is rumored to have typed:> >What I mean is this: If I do a search on my database for Myst (like the> >game), it returns entries with the word Myst but it also returns entries> >with words like mystery. I'd like it to return *just* the Myst records.>> Yes, you can: looking in the online docs under Searching/Word Breaks I>see that if you set fieldnameWORD=ww, then it looks for whole word matches.I can't believe that I never noticed that section before. Thanks for yourvery precise help.> >but webcat crashes> >my server if I do a search for a single letter, like X (which is the name> >of one of our products).>> That shouldn't happen, so should be considered a bug. Do you have enough>memory allocated to handle a huge amount of returned text when someone>looks for a single letter? Do you have the maximum number of returned>records set pretty low in your preferences?I have the maximum number prefs set to 500, and about 25 MB of RAMallocated to WebStar.MichaelMichael Winston *By Phone!: (503)/652/8815 x341Internet Coordinator *By e-mail!: michaelw@dhorse.comDark Horse Comics, Inc. *By web!: http://www.dhorse.com/
Michael Winston
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:
WebCat wont loose it's cookies! (1999)
WebCat2.0b15-to many nested [xx] tags (1997)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
Date Bug (1998)
New Web Site Developers Database (1996)
Weird problems with [SHOWIF]s (1997)
Incompatibility with WebCat 3 templates ... (2000)
Out of the woodwork (2007)
Paths (1998)
Updating Prices in Online Database (1999)
exclusive db lock with webcat-3 ? (2000)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Re1000001: Setting up shop (1997)
raw field names (2001)
New public beta available (1997)
Shipcost formula (2004)
Hairy Shipping Monster (2006)
Searching the same field with 2 form variables. (2000)
Writing to PDF (2003)
Sku numbers (1997)