Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Full-text Searches and Noise/Ignored words!

Author  Topic  cyx Starting Member 9 Posts Posted - 2001-01-11 : 07:48:13 Hello everybody! I've worked up a really cool Stored Procedure which performs a Full-text query on some tables, for my Search Engine. The SP is being accessed through a COM+ object I've written as well. My problem begins, when the user types in a search phrase which consists some or one Noise words. (Full-text ignored words). Which will then cause the SELECT query to crash in my Query analyzer: " A clause of the query contained only ignored words. " What happens from the site, if the user enters a noise word, and the COM+ object initiates and fire up the Stored procedure, it returns this wierd COM+ error back to the display: " Method '~' of object '~' failed " Now, this is because of the error that the Full-text query generated, I've tried to trap it with @@ERROR, but it stops right after the SELECT. Is there anything like ON ERROR RESUME NEXT in T-SQL ? I'm hopeless, clueless and lost, please help! ---------------------- Rafi B., Israel.