August 4, 2003 at 5:33 am
hi!
entered "for each" and received the following:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Execution of a full-text operation failed. A clause of the query contained only ignored words.
/sitesearch/cgi-bin/es/esearch.asp, line 167
thought maybe you'd want to know ...
best regards,
chris.
August 4, 2003 at 6:40 am
Hi Guys
Yep, got this a few times, but I have to say that the searching is very poor and at times, I struggle to get what I am after, even though I have a good idea of the topic from an article a few years back.
Personally, I have had a lot of success with full text using something like this example:
locking internals
lets changed to:
"lock*" NEAR "intern*"
with ranking, this search is effective, the cutting of the words and whacking on * or ** is the tricky bit really (ie. how far do you go etc), or even a basic parser that looks for "ind", "ly" at ends of strings and does the replacement.
With this, I would add a single drop down with"
+ articles
+ forum posts
+ tips/tricks
+ news
+ all (default)
Its about not getting overally complex with it all 🙂
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
August 4, 2003 at 12:05 pm
Apologies. The search has been a tough topic for us, trying to handle the different cases and the rapid growth of the site.
We bought some search engine, the name escapes me, but I'll try to get Mr. Knight to take a look.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply