PeteC
-
Total Posts
:
2
-
Reward points
:
0
- Joined: Feb 26 '03
-
Status: offline
|
Searching for " the" causes error
Fri. Feb 28, '03 6:15 PM
( permalink)
When I search for the word " the" I get the following error: Microsoft OLE DB Provider for SQL Server error ' 80040e14' Execution of a full-text operation failed. A clause of the query contained only ignored words. /searchpro.asp, line 377 Any ideas?
|
|
|
|
Samuel
-
Total Posts
:
11853
-
Reward points
:
180670
- Joined: May 23 '01
-
Status: offline
|
RE: Searching for " the" causes error
Fri. Feb 28, '03 6:22 PM
( permalink)
Hi Pete, The problem can be easily fixed. Look for this line in searchpro.asp: Line 353: ' on error resume next Please remove the comment to enable on error resume next. The full text search is very sensitive and searching with only ignored word will produce such error. Sorry for the inconvenience. [edit]I reuploaded the software with the new searchpro.asp. If you wish, you can download the software from v-share again. I only changed the " on error" thing I mentioned above.[/edit]
< Message edited by samuel -- 2003-02-28 18:31:09 >
ASPPlayground.NET ~ see our Version 4 plans here
|
|
|
|
PeteC
-
Total Posts
:
2
-
Reward points
:
0
- Joined: Feb 26 '03
-
Status: offline
|
RE: Searching for " the" causes error
Wed. Mar 5, '03 2:58 PM
( permalink)
It' s working now. Thanks much.
|
|
|
|