A clause of the query contained only ignored words

Using FULL-Text search in SQL server and fornt end is VB6.0
My SQL statement is:
"Select English,Japanese from (select English,Japanese from S_R_J_E
where CONTAINS(English,'WWW')) as EJ where English='WWW' "
But it cause problem when exact match for "WWW" is not found in
database and error message is shown:
"A clause of the query contained only ignored words."
I already known that it caused for noise.* files.
But how I can solve it.
Pls help.
Molay Ash
Molay
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message336819.htmlI don't do a lot of fulltext, but try this and see if it works any better
Select English,Japanese from S_R_J_E
where CONTAINS(English,'WWW')) and English='WWW'
It seems kind of strange that you would need to search for the word WWW with
fulltext when you are requiring that the entire field be EXACTLY 'WWW'.
You might also try the containstable command instead of contains... (Docd
in books on line)
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Molay" <Molay.10qdal@.mail.mcse.ms> wrote in message
news:Molay.10qdal@.mail.mcse.ms...

quote:

---

> Using FULL-Text search in SQL server and fornt end is VB6.0
> My SQL statement is:
> "Select English,Japanese from (select English,Japanese from S_R_J_E
> where CONTAINS(English,'WWW')) as EJ where English='WWW' "
> But it cause problem when exact match for "WWW" is not found in
> database and error message is shown:
> "A clause of the query contained only ignored words."
> I already known that it caused for noise.* files.
> But how I can solve it.
> Pls help.
> Molay Ash
>
> Molay
> ---
> Posted via http://www.mcse.ms
> ---
> View this thread: http://www.mcse.ms/message336819.html
>

---

A clause of the query contained only ignored words

Using FULL-Text search in SQL server and fornt end is VB6.0
My SQL statement is:
"Select English,Japanese from (select English,Japanese from S_R_J_E
where CONTAINS(English,'WWW')) as EJ where English='WWW' "
But it cause problem when exact match for "WWW" is not found in
database and error message is shown:
"A clause of the query contained only ignored words."
I already known that it caused for noise.* files.
But how I can solve it.
Pls help.
Molay Ash
Molay
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message336819.htmlI don't do a lot of fulltext, but try this and see if it works any better
Select English,Japanese from S_R_J_E
where CONTAINS(English,'WWW')) and English='WWW'
It seems kind of strange that you would need to search for the word WWW with
fulltext when you are requiring that the entire field be EXACTLY 'WWW'.
You might also try the containstable command instead of contains... (Docd
in books on line)
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Molay" <Molay.10qdal@.mail.mcse.ms> wrote in message
news:Molay.10qdal@.mail.mcse.ms...
> Using FULL-Text search in SQL server and fornt end is VB6.0
> My SQL statement is:
> "Select English,Japanese from (select English,Japanese from S_R_J_E
> where CONTAINS(English,'WWW')) as EJ where English='WWW' "
> But it cause problem when exact match for "WWW" is not found in
> database and error message is shown:
> "A clause of the query contained only ignored words."
> I already known that it caused for noise.* files.
> But how I can solve it.
> Pls help.
> Molay Ash
>
> Molay
> ---
> Posted via http://www.mcse.ms
> ---
> View this thread: http://www.mcse.ms/message336819.html
>

547 error: help decoding

Can someone explain in more detail, or in plain english, what this error is trying to say.. ?

"An SQL error occured - 547 error: INSERT conflicted with column Foreign Key constraint 'Employee_FK00'. The conflict occured in database NAME, table 'Union', column 'UnionName'. "

I get this error aftering trying to add a new row in my .Net Winform i'm developing. Thanks!It looks like you are trying to insert a row in a child table without a parent row. Make sure that there is a row in the table that 'Employee_FK00' is referencing before you do the insert.|||Well.. more specifically, there are two tables 1. Employee and 2. tbl_Union. In the employee table there is Lastname, firstname, EmployeeID, and Union. All the different Unions are in the tbl_Union, with a Union# and Union Name field. Both tables have rows in them.

The vb.net Application was taking the Union# from the tbl_Union and inserted the value in Union under Employee. But i keep getting that SQL error.|||According to the error message, the foreign key is trying to match on UnionName, not Union#. Can you provide the DDL for the tables, including the foriegn key constraint definition?|||Sure can, but i need your help. What is the best way to get this information? I'm new to this... :p|||It depends. I just need the column names of the tables and the foreign key definition. I suspect that you are populating the union#, but for some reason, the foreign key is trying to point to UnionName.|||Well there is the "EMPLOYEE" table, which has fields Employee# (Primary Key), lastname, firstname, union. Then, there is the "UNION" table with fields, Union# (Foreign key), and UnionName. That's the basics...|||What DBMS are you using? What columns in the UNION table is the Foreign Key constraint 'Employee_FK00' referencing?|||I'm using MS SQL 2000...

What columns in the UNION table is the Foreign Key constraint 'Employee_FK00' referencing?

It is the Union# column.|||I think you have your foriegn key defined incorrectly. If you look at the error message, it is trying to find a parent record with matching column 'UnionName' instead of Union#.|||Actually, that is a error on my part, its not the 'UnionName', but the 'Union#'. I typed that wrong in my original statement. :(

I'm currently in the SQL Server enterprise design area on the tables, looking at the indexes/keys tabs, etc. I guess this is the area I need to play in to figure it out. Thanks!|||I also found this thread that deals with the same situation I think.. http://www.dbforums.com/t700898.html

I did upgrade from access 2000 to ms sql as well, if that messed something up - I dont know.

547 error: help decoding

Can someone explain in more detail, or in plain english, what this error is trying to say.. ?

"An SQL error occured - 547 error: INSERT conflicted with column Foreign Key constraint 'Employee_FK00'. The conflict occured in database NAME, table 'Union', column 'UnionName'. "

I get this error aftering trying to add a new row in my .Net Winform i'm developing. Thanks!This might be because you are trying to inserting a detail record that expects a header record to exist in another table.

For example, say you are trying to insert 'Union_1' into column in a table (employee?), but that table has a constraint where 'Union_1' MUST exist in table union in column unionname. If 'Union_1' does not exist in union, it is not going to allow you to insert it into the other table.

BTW, Union is a keyword so I'd be careful with using it as a table name.

Select * from a
union
select * from b