Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Re: Index Server - How do I avoid an error when only ignored words ar- e entered?


Message #1 by dgrimshaw@k... on Fri, 27 Sep 2002 12:59:17
Hi 

Do you have a solution to this as I have the same problem.

Thanks
Darren

> Hi,
> 
> If a user enters only noise/ignored words for their search phrase, I get 
an
> ugly error saying:
> 
> CreateRecordset error '80041605' 
> The query contained only ignored words. 
> /FSMA/results.asp, line 17 
> I can't find any documentation covering this - I assume you have to check
> for the error occurring and then deal with it, but am unsure how to do 
this.
> Is it an ADO error, a VBScript error or an IIS error I need to check for?
> Any help would be really appreciated,
> Colin
> 
> ---
> Colin Montgomery
> Clifford Chance LLP
> Finance & Capital Markets (Lon)
> colin.montgomery@c...
> * +44 (0)20 7006 2503
> ---
> 
> 
> 
> *******
> 
> This message and any attachment are confidential and may be privileged 
or otherwise protected from disclosure.  If you are not the intended 
recipient, please telephone or email the sender and delete this message 
and any attachment from your system.  If you are not the intended 
recipient you must not copy this message or attachment or disclose the 
contents to any other person.
> 
> For further information about Clifford Chance please see our website at 
http://www.cliffordchance.com or refer to any Clifford Chance office.
Message #2 by Colin.Montgomery@C... on Mon, 30 Sep 2002 11:44:10 +0100
not really Darren, but here's what I suggested to someone else a while back
(think they contacted me directly so it may not appear in the thread).
-----------------------

Sorry, but no, I didn't find a solution to this.  Due to time constraints I
simply cleared the 'Noise' file.  This file contains, by default, all the
words you would normally want to ignore, such as 'the', 'of' etc.  If you
clear this file of all entries, there will be no ignored words, so the
CreateRecordset error '80041605' - The query contained only ignored words  -
error will never occur.

If you want to pursue it further though, I reckon you could leave your noise
file as it is and code like the following:

err.number = 0
On Err0r Resume Next
'try to open the record5et using the search/indexing object
If err.Number <> 0 Then
	Resp0nse.write "Only ignored words were contained in your query,
please "
	Resp0nse.write "<a href='thisPage.asp'>try Again</a>"
Else
	'continue with displaying results
End If

This is just quickly written code to give you an idea, so it's not been
tested etc.  If you get this to work, maybe you'd be kind enough to post it
to the ASP_DATABASES forum list?

Hope this helps,
Col

-----Original Message-----
From: dgrimshaw@k...
[mailto:dgrimshaw@k...]
Sent: 27 September 2002 13:59
To: ASP Databases
Subject: [asp_databases] Re: Index Server - How do I avoid an error when
only ignored words ar- e entered?


Hi 

Do you have a solution to this as I have the same problem.

Thanks
Darren

> Hi,
> 
> If a user enters only noise/ignored words for their search phrase, I get 
an
> ugly error saying:
> 
> CreateRecordset error '80041605' 
> The query contained only ignored words. 
> /FSMA/results.asp, line 17 
> I can't find any documentation covering this - I assume you have to check
> for the error occurring and then deal with it, but am unsure how to do 
this.
> Is it an ADO error, a VBScript error or an IIS error I need to check for?
> Any help would be really appreciated,
> Colin
> 
> ---
> Colin Montgomery
> Clifford Chance LLP
> Finance & Capital Markets (Lon)
> colin.montgomery@c...
> * +44 (0)20 7006 2503
> ---
> 
> 
> 
> *******
> 
> This message and any attachment are confidential and may be privileged 
or otherwise protected from disclosure.  If you are not the intended 
recipient, please telephone or email the sender and delete this message 
and any attachment from your system.  If you are not the intended 
recipient you must not copy this message or attachment or disclose the 
contents to any other person.
> 
> For further information about Clifford Chance please see our website at 
http://www.cliffordchance.com or refer to any Clifford Chance office.

  Return to Index