Hi, I'm using MySQL fulltext indexes in a Rails 2.3.2 App. I added the index via native SQL in my migration. But there is a known issue causing problems with the schema.rb. Rails doesn't understand fulltext indexes and tries to create a normal index. This will cause an error when creating the database from schema.rb (eg testing, specs, ...
I posted a question yesterday about using Nhibernate search with nhibernate v2 and have recieved no responses. This has confirmed to me that I need to reconsider using NHibernate.Search and look at an alternative full text search solution. I want to be able to index and search documents and display the relevant extracts of the documents ...
There are two tables with no relation defined eg : Bugs and Comments For each bug id there are multiple comments.Suppose I am using a query like select b.bugid,b.bugtitle,c.comment from bugs b , comments c where b.bugid = c.bugid In hibernate search ,is there any method to write text queries for multifield searches ? In case, for a...
Not sure what's happening with this, but here's my question. I have a Sql Server 2008 database that I need to be able to do full-text indexing/searching but when I try to setup my indices on the table, I get the following: I've tried running this stored procedure on my database and it's successful: EXEC sp_fulltext_database @action ...
Hello, I'm using SQL Server 2008 and I have a view that looks like this: select ID, dbo.functionname(ID) from tablename I'm trying to put a full-text index on this, but it doesn't seem to have a unique index that I can go off of. The tablename.ID is the unique identifier. I tried creating an index on it, but it says it cannot schema ...
I'm using SQL Server 2008 and I would like to use a sproc to tell the database to populate a full-text index. If available, I'd like to know what the sprocs are for the following actions: adding an entry into the index removing an entry into the index full populate ...
Hi folks, I have a Full Text Catalog on single table, with three fields defined :- TABLE: Animals Fields: Name, Breed, LatinName. Now, the Catalog seems to be working perfectly. eg. CREATE FUNCTION AnimalSearch ( @Name NVARCHAR(200) ) RETURNS TABLE AS RETURN ( SELECT KEY_TBL.[Key] as Name, KEY_TBL.RANK as Relevan...
I have set up the full-text search functionality in SQL Server 2008 express. This is what I did: -- STEP 1: Create catalog create fulltext catalog HtmlSearch -- STEP 2: Fill catalog create fulltext index on docs (WordHtml) key index IX_docs_1 on HtmlSearch with change_tracking auto -- STEP 3: Search select * from docs where freetext(*...
Hi folks, I've got a full text catalogue setup. It has a unique key count of 117 with 19 items. The table has 19 rows only. The table has an NVARCHAR(50) field called ClientGuid. It's a guid with some weird text at the end. eg.. 8b6ef4a504dd1a57f079180e7f6eb4a0(-) 8b6ef4a504dd1a57f079180e7f6eb4a0(OK) (and no, i didn't defined th...
When i execute the following sql, nothing happens: select * from docs where freetext(*, 'my search string') I know that "my search string" is in a field in a table. The table docs is added to my catalog. The field to search in contains html content. ...
I have a working search query with the new Text Search functions in DB2 9.5.2: select * from prevue.mysearchabletable mst where contains(mst.searchabletext, 'porsche') = 1; However, this only tells me which ones match, as well as what the score is (score function has been omitted for brevity). Is there a way to use the text search in...
I'm using the acts_as_tsearch plugin for rails to do full text searching with Postgresql. They give an example of multi table search here: http://code.google.com/p/acts-as-tsearch/wiki/ActsAsTsearchMethod But that only does a one-to-many relationship. I'm trying to get it to also search a many-to-many relationship (has_and_belongs_to_...
I have the following SQL query: SELECT TOP 200 * FROM article WITH (nolock) WHERE CONTAINS(*,'"ram*" and "1*"') ORDER BY article_number I am getting no results returned within 10 minute. If I stop the query after a few minutes then it returns a few records. In article table there are 10,000 records. The full text catalog is on artic...
Hello, I've got a search box that users can type terms into. I have a table setup with fulltext searching on a string column. Lets say a user types this: "word, office, microsoft" and clicks "search". Is this the best way to deal with multiple search terms? (pseudocode) foreach (string searchWord in searchTerms){ select col1 f...
I've just started out using ASP.NET MVC and TDD. I've read that while unit testing you should focus on testing your code, not other systems, like the DB. However, what happens when essential functionality is residing in the DB? I've used the MVC Storefront series as an initial guide in how to set up my projects and patterns. As full tex...
I'm offering a search option for my users. They can search on city name. The problem is that my city names I have stored are things like "Saint Louis". But I want to find Saint Louis even if the user types in "St. Louis" or "St Louis". Any suggestions on how I could create a lookup table to take that into account somehow? ...
I am currently performing a full text search on my "pages" in a database. While users get the results they want, I am unable to provide them with relevant information as to why in the world the results that came up, came up. Specifications on what I am looking for: I have HTML Data, meaning that if you search for a term such as "test"...
Hi, I would like to hear if any of you have an idea to do the following: I have one table containing some cardefinitions [id][Company][Mode], this could e.g. be Audi 100, Ford Mustan etc. I then have another field which is a string containing both the car and the model, this could be "Ford Mustang 2.5T", I then need to find the correct I...
I am using SQL Server 2000 and I am using full text indexing on a table. Can I use full text indexing on a view of this table? If yes, then how can I use? If no, then what should I do? Actually, I am doing refinement of the results obtained from a table and for this refinement I am using a view of this table... ...
I'm attempting to using Sphinx in my CMS as a sitewide search. Since each model in the CMS has different fulltext fields, I've created an index per model. However, according to Sphinx's forum, searching over multiple indexes with different schema is not supported. How are you CMS guys using Sphinx for your general site search? Perfor...