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 your very 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 RAM allocated to WebStar.MichaelMichael Winston *By Phone!: (503)/652/8815 x341 Internet Coordinator *By e-mail!: michaelw@dhorse.com Dark 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 your very 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 RAM allocated to WebStar.MichaelMichael Winston *By Phone!: (503)/652/8815 x341 Internet Coordinator *By e-mail!: michaelw@dhorse.com Dark 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:
Fwd: virtual domain and [listfile] paths and aliases (1998)
WebCatalog2 Feature Feedback (1996)
Car Database (2002)
Templates on Unix & CGI on Mac? (1997)
A little syntax help (1997)
bug in [SendMail] (1997)
Uh...can someone help me out with the b10? (1997)
problems with 2 tags (1997)
RE: NewCart+Search with one click ? (1997)
Replacing a Word (1999)
searchable list archive (1997)
5.0 Pricing (2003)
send mail problem? (1997)
ShowIf variables (1997)
RE: Error -108 (1997)
using showpage and showcart commands (1996)
Searching multiple fields from one form field (1997)
ShowCart (2001)
Include vs. lookup? (1998)
2.01 upgrade problems (1997)