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.
| Author |
Topic |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2001-01-22 : 04:55:55
|
| Im still stumped on this one! - when doing a full text search from ASP to a stored proc, if a user enters a noise word (such as 'and') I get the error message:Error Type:Microsoft OLE DB Provider for SQL Server (0x80040E14)The query contained only ignored words. I have tried to trap the @@error in the Stored Proc that executes the search but it doesnt seem to trap it! So my question is - Does SQL Server treat the occurences of NoiseWords in the result as an error?If not then how do we trap these Noisewords?I have used the following in my stored proc to rollback if there is an error returned:If @@error <> 0 thenrollback tranAgain - any help would be greatly appreciated.Matt |
|
|
|
|
|
NoiseWords