Help on Ignored Words in Full Text Query

I'm implementing the search features on a web site.
If I search for several words not in the noise file everithing is ok.
If I search with several words and only one of it is in the noise file
the query fails with
Execution of a full-text operation failed. A clause of the query
contained only ignored words.
Why say me that the clause contain only ignored words?
This is the query:
SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "close" AND
"window"')
SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "from" AND
"window"')
Thanks a lot for your help!!
Andrew
"From" is considered to be a noise word and can trigger this error. The best
approach for smaller tables you are Full Text Indexing is to empty the
contents your noise word list and replace it with a single space.
To do this go to a command prompt and type net stop MSSearch and press enter
Go to go to c:\Program Files\Microsoft
SQLServer\mssql\ftdata\sqlserver\config. Then edit the noise.enu (for US
English) in notepad, press ctrl and A, and then press the space bar. Then
select File and Save.
Then restart MSSearch.
You should then do a full population.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Andrew" <a.fileccia@.contactaspa.com> wrote in message
news:53107877.0412040626.80f78c3@.posting.google.co m...
> I'm implementing the search features on a web site.
> If I search for several words not in the noise file everithing is ok.
> If I search with several words and only one of it is in the noise file
> the query fails with
> Execution of a full-text operation failed. A clause of the query
> contained only ignored words.
> Why say me that the clause contain only ignored words?
> This is the query:
>
> SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "close" AND
> "window"')
> SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "from" AND
> "window"')
> Thanks a lot for your help!!
> Andrew
|||Andrew,
This is a common question on this newsgroup and one that can be workaround,
via either client-side or server-side solutions. As for the text of the
message, I agree that it is badly written as most often the query will not
contain only noise words, but in fact one or more depending upon how the
search words are specified in the search condition.
I'd recommend that you review SQL Server 2000 BOL title "Full-text Search
Recommendations", and KB article 246800 (Q246800) "INF: Correctly Parsing
Quotation Marks in FTS Queries" at
http://support.microsoft.com//defaul...b;EN-US;246800 (with T-SQL,
JavaScript, & VBScript coding examples) and search this newsgroup for
SearchPage.htm (or SearchPage.zip) for server-side and client-side solution
of removing the noise words before issuing a SQL FTS query.
Hope this helps!
John
"Andrew" <a.fileccia@.contactaspa.com> wrote in message
news:53107877.0412040626.80f78c3@.posting.google.co m...
> I'm implementing the search features on a web site.
> If I search for several words not in the noise file everithing is ok.
> If I search with several words and only one of it is in the noise file
> the query fails with
> Execution of a full-text operation failed. A clause of the query
> contained only ignored words.
> Why say me that the clause contain only ignored words?
> This is the query:
>
> SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "close" AND
> "window"')
> SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "from" AND
> "window"')
> Thanks a lot for your help!!
> Andrew
sql

Help needed with a query

Hi everyone,
I am implementing a dating club as a project for school.
I have a table called "Dates". It has the columns:
DateID, FirstMember, SecondMember, DateToMeet, Place
The table "MEMBERS" contains many things and of course:
MemberID , Username
Now, I want to make a query where I can join the two tables and display:
USERNAME1, USERNAME 2 (the 2 members that are going to meet), DateToMeet and
PLACE.
But the problem is tha both "FirstMember" and "SecondMember" of the table
"Dates" refer to he same column (namely "MemberID" ) of the table MEMBERS.
How can make such a query?
ThanksYou use a technique called aliasing where you give each logical table in
your query a unique name to which you will refer to it by in the rest of the
query, you can then refer to the same table multiple times.
SELECT Dates.DateToMeet, Dates.Place, First.UserName as Member1,
Second.UserName as Member2
FROM Dates
JOIN Members as First ON First.ID=Dates.FirstMember
JOIN Members as Second ON Second.ID=Dates.SecondMember
the 'as' is optional but it helps you to see where aliasing is used.
Mr Tea
http://mr-tea.blogspot.com
"Silver" <argytzak@.med.auth.gr> wrote in message
news:ct03t1$8p8$1@.nic.grnet.gr...
> Hi everyone,
> I am implementing a dating club as a project for school.
> I have a table called "Dates". It has the columns:
> DateID, FirstMember, SecondMember, DateToMeet, Place
> The table "MEMBERS" contains many things and of course:
> MemberID , Username
> Now, I want to make a query where I can join the two tables and display:
> USERNAME1, USERNAME 2 (the 2 members that are going to meet), DateToMeet
> and
> PLACE.
> But the problem is tha both "FirstMember" and "SecondMember" of the table
> "Dates" refer to he same column (namely "MemberID" ) of the table MEMBERS.
> How can make such a query?
> Thanks
>|||Silver wrote:
> Hi everyone,
> I am implementing a dating club as a project for school.
> I have a table called "Dates". It has the columns:
> DateID, FirstMember, SecondMember, DateToMeet, Place
> The table "MEMBERS" contains many things and of course:
> MemberID , Username
> Now, I want to make a query where I can join the two tables and
> display: USERNAME1, USERNAME 2 (the 2 members that are going to
> meet), DateToMeet and PLACE.
> But the problem is tha both "FirstMember" and "SecondMember" of the
> table "Dates" refer to he same column (namely "MemberID" ) of the
> table MEMBERS.
> How can make such a query?
> Thanks
You can join to the same table as many times as you want, using table
aliases to distinguish them (this example is untested, but should give you
the basic idea):
select
u1,UserName Dater1,
u2.Username Dater2,
DateToMeet,
Place
FROM Dates d
inner join members u1 on d.FirstMember=u1.MemberID
inner join members u2 on d.SecondMember=u1.MemberID
Bob Barrows
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"|||Thank you both for the quick reply.
I tried both ways and managed to get results. The problem is, I get mopre
results than I should. It's like somewhere happens a cartesion product.
My table Dates is like this:
DateID - User1 - User2 - DateToMeet - Place
----
--
1 1 2 1956-10-30 22:00:00.000 Plat.
Aristotelous
2 1 3 1996-10-30 22:00:00.000
Tsimisky,Gounari
3 4 5 2004-01-02 22:00:00.000 Colonial
4 3 6 2003-04-04 22:00:00.000
Terkenli,Aristotel
5 2 5 2003-02-06 21:30:00.000 Ster Century
I should only get 5 results, with the Usernames of the Members.
i'm working on it right now, but if you have any idea, pls share
Thanks again!!|||Silver wrote:
> Thank you both for the quick reply.
> I tried both ways and managed to get results. The problem is, I get
> mopre results than I should. It's like somewhere happens a cartesion
> product.
> My table Dates is like this:
www.aspfaq.com/5006

> DateID - User1 - User2 - DateToMeet - Place
> ----
--
> --
> 1 1 2 1956-10-30 22:00:00.000 Plat.
> Aristotelous
> 2 1 3 1996-10-30 22:00:00.000
> Tsimisky,Gounari
> 3 4 5 2004-01-02 22:00:00.000
> Colonial 4 3 6 2003-04-04 22:00:00.000
> Terkenli,Aristotel
> 5 2 5 2003-02-06 21:30:00.000 Ster
> Century
>
> I should only get 5 results, with the Usernames of the Members.
> i'm working on it right now, but if you have any idea, pls share
> Thanks again!!
Show us your DDL, sample data and current query.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"|||Bob's query has a common copy and paste oversight in it that will give you a
cartesian product, see if you can spot it.. or use mine :)
Mr Tea
http://mr-tea.blogspot.com
"Silver" <argytzak@.med.auth.gr> wrote in message
news:ct06f5$bd7$1@.nic.grnet.gr...
> Thank you both for the quick reply.
> I tried both ways and managed to get results. The problem is, I get mopre
> results than I should. It's like somewhere happens a cartesion product.
> My table Dates is like this:
> DateID - User1 - User2 - DateToMeet - Place
> ----
--
> --
> 1 1 2 1956-10-30 22:00:00.000 Plat.
> Aristotelous
> 2 1 3 1996-10-30 22:00:00.000
> Tsimisky,Gounari
> 3 4 5 2004-01-02 22:00:00.000 Colonial
> 4 3 6 2003-04-04 22:00:00.000
> Terkenli,Aristotel
> 5 2 5 2003-02-06 21:30:00.000 Ster
> Century
>
> I should only get 5 results, with the Usernames of the Members.
> i'm working on it right now, but if you have any idea, pls share
> Thanks again!!
>|||My current query is this
SELECT DISTINCT FirstU.Username as Member1,SecondU.Username as Member2,
D.DateToMeet,D.Place
FROM Dates AS D
INNER JOIN MEMBERS AS FirstU ON FirstMember=D.FirstMember
INNER JOIN MEMBERS AS SecondU ON SecondMember=D.SecondMember
WHERE (FirstU.Username != SecondU.Username)
I have already given the sample data for the table "Dates". It contains 2
columns, "FirstMember" and "SecondMember" that contain an int value, which
refers to the table "MEMBERS", column "MemberID". That is, a "1" in
"FirstMember" corresponds to a tuple in the table "MEMBERS" that has "1" as
MemberID and "Nick" as UserName
"Bob Barrows [MVP]" <reb01501@.NOyahoo.SPAMcom> wrote in message
news:OdXIwvUAFHA.3016@.tk2msftngp13.phx.gbl...
> Silver wrote:
> www.aspfaq.com/5006
>
> ----
--
> Show us your DDL, sample data and current query.
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>|||Silver wrote:
> My current query is this
> SELECT DISTINCT FirstU.Username as Member1,SecondU.Username as
> Member2, D.DateToMeet,D.Place
> FROM Dates AS D
> INNER JOIN MEMBERS AS FirstU ON FirstMember=D.FirstMember
> INNER JOIN MEMBERS AS SecondU ON SecondMember=D.SecondMember
> WHERE (FirstU.Username != SecondU.Username)
> I have already given the sample data for the table "Dates".
If you want me to take a deeper look at this you will provide DDL scripts
(CREATE TABLE statements) and sample data in the form of INSERT statements
(The faq article, www.aspfaq.com/5006, links to a script that shows you how
to generate those INSERT statements) so I can reproduce your problem on my
server. You're asking me for help. Does it seem polite to make me to go to
extra work to provide that help? :-)
Bob Barrows
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"|||Lee Tudor wrote:
> Bob's query has a common copy and paste oversight in it that will
> give you a cartesian product, see if you can spot it.. or use mine :)
>
Yes it does, darnit. But yours should work, and he says it doesn't ...
Bob
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"|||On Sun, 23 Jan 2005 15:17:15 +0300, Silver wrote:

>My current query is this
>SELECT DISTINCT FirstU.Username as Member1,SecondU.Username as Member2,
> D.DateToMeet,D.Place
>FROM Dates AS D
> INNER JOIN MEMBERS AS FirstU ON FirstMember=D.FirstMember
> INNER JOIN MEMBERS AS SecondU ON SecondMember=D.SecondMember
>WHERE (FirstU.Username != SecondU.Username)
Hi Silver,
Your join criteria are wrong. The unqualified FirstMember is taken from
the Dates table, as there is no other table with a column of that name;
the other FirstMember is also from Dates because that is what the alias D
is used for. And since all rows will satisfy the requirement that
FirstMember is equal to itself (and ditto for SecondMember), you'll get a
full cartesian product from the join, that is then slightly reduced by the
WHERE clause.
Try this:
SELECT FirstU.Usersname as Member1, SecondU,Username AS Member2,
D.DateToMeet, D.Place
FROM Dates AS D
INNER JOIN Members AS FirstU
ON FirstU.MemberID = D.FirstMember
INNER JOIN Members AS SecondU
ON SecondU.MemberID = D.SecondMember
The WHERE clause is not needed. I assume the dates table doesn't contain
any dates between a member and him-/herself. The only effect of the where
clause would be to remove valid dates between two people who happen to
have the same name.
I also removed the DISTINCT, as it doesn't appear to be necessary.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

help me gauge the effort in my first db setup

Hello there... Happy New Year!

A client of mine, a group of 4 doctors, are interested in implementing a small office network in which they will switch to a digital filing system. I have recommended a Microsoft Server 2003 system, therefore the patient information will be stored in the SQL server.

I have never administered, administrated?? (see, I really need help here!) a database, but have built small databases from scratch in C and with Access, so I feel confident that I could set up a system for them. I need to have some kind of estimate, both a fee and implementation schedule. Can you help me get a handle on the scope of this?

Many thanks,
BrynYou Access experience will give you a leg up on the learning curve for developing a SQL Server database, but you will still have a lot to learn about administration. Security (which I think would be important for a doctors office) is much different, but is also much better and much simpler in SQL server than in Access. You will also need to write your SQL queries, so I hope that you are somewhat fluent in that and have occasionally looked at the SQL code that Access creates. Be aware that there are some subtle differences between SQL Server SQL and MS Access SQL.

Your best for a small application like this is to create it as an MS Access ADP project. This will allow you to use Access as an efficient interface to SQL Server. This is not the best solution for large applications, but for what you are describing it should be fine. If they want to scale it up in the future, they can drop the Access interface and still retain the SQL Server database with a new interface.

I can't, of course, give you an estimate on how long it will take you to complete it. Personally, since you are learning on the job, I think you should quote them based on how long it would take to develop the database in MS Access and consider any additional time as training and career development.

blindman|||You have many client tools in sql server that you need to research:

Enterprise Manager - This is a gui interface to manage your sql server instances.
Query Analyzer - Interface to run/test transact-sql statements.
BOL - Books Online - This is the online reference guide to sql server - You will use this frequently as you work with sql server. (Almost) Any question you have, go here first.
Profiler - captures events from sql server - allowing you to debug/analyze a problem/performance.

For books, look for books by Ken Henderson, Mark Spenik and Staneks pocket admin.