I want to create a stored procedure to do some combined keyword search using CONTAINS,something like below: SELECT theContent FROM FtsTest WHERE CONTAINS (theContent, ' FORMSOF (INFLECTIONAL, keyword1) AND FORMSOF (INFLECTIONAL, keyword2)'); and he number of keywords may vary, so I tried to pass the whole 'FORMSOF... AND FORMSO...
I'm using MySQL & ColdFusion. Currently for searching TEXT fields I'm using LIKE in the database. Luckily my database is empty but soon the table will fill up and I fear I the LIKE SQL query will kill my app. I'm looking for a solution that works with both MySQL & ColdFusion that will allow me to scalably offer search capabilities with ...
Hi all, currently I am trying to get the full text search of the SQL Server 2005 to work. I've got a table where all string columns are populated in a full text catalog. Now I want to search within these columns. E.g. a row in the first column contains "Name123", the second column contains "LegalForm123" The second row in the first c...
Using ContainsText, If I search: "Report Part 1" in quotes it returns the correct result (Report Part 1). However, if I search: Report Part 1 it gives me zero results. My understanding was that full-text would take out the 1 as a noise word, and then do a search for contains Report and Part. I assumed that the results would give me Rep...
For a long time now I've been having a problem with using the verity search service bundled with ColdFusion 8. The issue is with timeout errors occurring when perfoming any operation on a collection. It's intermittent, and usually occurs after a few operations have been successfully performed. For instance: If I'm adding records to a co...
how you all deal wich such issue of occasionally need to reindex? what recommendation do you suggest to minimize this? ...
Hi, I'm looking for a good solution to use the containstable feature of the SQL Serve r2005 effectivly. Currently I have, e.g. an Employee and an Address table. -Employee Id Name -Address Id Street City EmployeeId Now the user can enter search terms in only one textbox and I want this terms to be split and search with an "AND" opera...
Hi all, I am currently working on a project where I want to search for employees via just one input search term. For this I am using the SQL FTS. The table schema looks like this Employee table EmployeeId, Firstname, Lastname Sample data 1, John, Miller 2, Chuck, Norris Address table AddressId, EmployeeId, CityId, Street, Str...
The line below fetches all files that start with Cake. Dim fi As System.IO.FileInfo() = di.GetFiles("Cake*") How can i write the search pattern to get all the files, that do not start with Cake? ...
We have table with several full text indexed fields. Say, it is firstName, surName and lastName. I'm looking for "John AND Smith" and obviously these two words most likely will be written in different fields. Query returns nothing. If I search for "John OR Smith" it is working. The question is: can I somehow tell SQL Server that all fie...
Why not integrated Soundex into Full-Text search in SQL server? Those functions good for SQL query and easy to use for traditional ASP.NET app, but it is very hard to use it on Silverlight app because SL app use Linq to get data and Stored Procedure is very hard to use. (Complex datatype for result set is not supported yet). How to res...
I have a php/mysql directory. If someone searches a company name like "Johnson & Johnson" and it's it the DB as "Johnson and Johnson" it doesn't match. I'm doing a NAME LIKE '% var %' kind of search currently. Is there an easy way to get this to work? I'm not sure if it's just a matter of setting up the table as INNODB with full text on...
Is it possible to implement google style search on SQL server database on tables and columns? Some examples: I have 5 tables with 25 columns(each has 5 columns), I want to the search can across different tables and columns in one query as sql serverl full-text search only limit on one table, not sure what's the solution if want to searc...
Both Entity Framework and NHibernate are O-R mapping framework. Hibernate can use Lucene as full-text solution. Is there any solution combine Entity framework and Lucene for searching? Where to find out the example/resource for this solution? ...
How do you add a column to a fulltext search in MySQL to indicate which words were included in the search? ...
Suppose I have following two tables: Employee(Name, description, departiemtID,...) --foreign key: departmentID Department(departmentID, name, description, ...) I want to full-text search on Employee.Name, Employee.description, department.Name, department.description. What's the best solution for this case? Demo query please. ...
Hi All, We are using ADO.NET dataservices & are building URL based filters. Example: /Customers?filter=City eq 'London' We now need to filter on a Full Text 'tags' Field. WAS HOPING FOR: /Customers?filter=Tag like 'Friendly' PROBLEM: ADO.NET does not have a LIKE operator. ADO.NET does not seem to like FTS (It is not finding a match - b...
I'm having some difficulty determining what search solution to use in my new iPhone application. The data structure I have is a hierarchy plist that describes a table of contents that link to an HTML file stored locally. I only have two levels in the TOC (Chapter and Section) so it nicely fits into a UITableView with headers and cells. T...
I've looked into SQL 2008's built-in Full-Text search, and also Lucene.NET.. but I don't think they'll do what I need to do. And I just want to make sure I'm building my program as efficient as possible. So here's the dream. I want to have a single textbox on a page (like google) and allow the user to enter ANYTHING in. And based on ...
I am using Perl's KinoSearch module to index a bunch of text. Some of the text has numeric fields associated with each word. For example, the word "Pizza" in the index may have a dollar field value like "5.50" (dollars). How can I write a query in KinoSearch that will find all words that have a dollar value greater than 5? I'm not e...