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:
SHOWNEXT (1999)
Orders coming up blank (2004)
Add a field to the error log? (1997)
webcat2b12 CGI -- Date comparisons (1997)
Which GUI HTML editors work with WC ? (1997)
Search Philosophy (2001)
hierarchy question... (2000)
Tip for making barcharts (1997)
Setting up WebCatalog with Retail Pro data (1996)
Purchae error - Fixed to a degree (1997)
Backwards list behavior ... (1997)
WebCat Talk Arhives... (1998)
no global [username] or [password] displayed ... (1997)
Non-repeating Random Numbers (2002)
[WebDNA] PayPal Instant Payment Notification Guide (2009)
RE: search same field twice??? (1999)
WebCatalog can't find database (1997)
Fwd: Problems with Webcatalog Plug-in (1997)
search question (2001)
[WebDNA] OSX users (2009)