Hi, I have created a full text index on my dev server on a view that returns few rows. The population schedule is currently set to run once a day. However the full text index is returning no results as though it is not populated. If I run SELECT FULLTEXTCATALOGPROPERTY('My Catalog', 'PopulateStatus'), the result is always 1, indicatin...
I've obtained the handle to a processes Main Window and would like to force that window to full screen. I'm programming in c#.Net with .Net framework V2.0 SP1 ...
Here's what I'm trying to do. User (a): Enters data in two fields (description-1) and (description-2). User (b) Enters similar data in opposite fields. User (a) or (b) search on both fields would find a match. A good analogy would be a dating search. User (a) enters a description of themselves and the match they are looking for, and...
Is there a way to use a full server path instead of a url when submitting a form via ajax with jquery? The exemple below doesn't work but it will give you an idea of what I'm trying to do. I know you can't do cross domain ajax requests but this is all on the same physical server. I don't want to set up proxy or anything too fancy, if t...
I have already posted a question about this, but the situation has changed sufficiently to warrant a new one. I have a MySQL table called aromaProducts in which there are 7 columns with the FULLTEXT index, and which has three records in it. When I make a query against it like: SELECT * FROM aromaProducts WHERE MATCH (title) AGAINST ('...
Have full text index on a table for the purpose of searching and producing a list of results based on relevance, I assign relevance based on the highest "score" from the full text index. The table contains 3 columns, a unique ID, a text field in the type (varchar), and the third is a timestamp of the last edit. The full text index only ...
Hello, I'm experiencing weird behavior with some of full text search queries, especially those with multiple words. These are working fine when executed thru Management Studio but returning no results when called from a code. I did a SQL Trace to see what commands are being sent from my app and exactly same command come with results wh...
I want to display event of json from mysql database. But i can't display it in calendar. I think there are some mistakes in events. But i can't point it out. Here is my code: calendar.php: $(document).ready(function() { var date = new Date(); var d = date.getDate(); var m = date.getMonth(); var y = date.getFullYear(); $(...
how can i get the full url like:http://www.domain.com/page.php?id=someid&page=1 ? not just http://www.domain.com/page.php ...
hi guys, I'm trying to use jquery Full Calendar from http://arshaw.com/fullcalendar I searched the docs alot but I could not find how I can retrieve the current month a user is on at a certain moment. On render it is set as the current month in the title, but I cant find a way to use that info. I want to sent the month to my ajax call ...
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...
I have 2 tables nsk_UserInfo and Photos. I use full text search query to show result SELECT nsk_UserInfo.User_ID , nsk_UserInfo.Name , nsk_UserInfo.Contact_Person , nsk_UserInfo.Address, Photos.Photo1 as 'Photo' FROM nsk_UserInfo INNER JOIN Photos ON nsk_UserInfo.User_ID = Photos.User_ID WHERE FREETEXT ((nsk_UserIn...
Suppose you have huge amount of documents, a few millions, and more coming. Suppose you have to publish them on a website with hundreds of thousands of daily pageviews, and suppose you have to let the visitors perform searches on all the documents. What is the best way to store/retrieve the documents? And to perform searches on them? Cu...
Hi, I'm looking for a full text search algorithm that will allow to find similar program names, for example "Mozilla Firefox" and "Firefox 3.5, or "Adobe Reader" and "Adobe Acrobat Reader v10". The Levenshtein distance is too inefficient in this case, since spelling doesn't change. It has to use serial scanning (not indexing). I need...
I am doing a Full Motion Recording of my Browser window. The recording lasts about 45 seconds, and I do a couple of different things during that recording. When I go to view the recording I just did in a slide, the screen capture is about 45 seconds, but all the actions that I've done during the recording seem sped up. This is causing m...
I got a big table with around 10 million records. The table is part of full text index and the data contained in it is recreated daily. Now after recreating the data I rebuild the full text index using SQL: ALTER FULLTEXT INDEX ON [table1] START FULL POPULATION; The issue is that the folder containing full text index files size is gro...
Full text search is becoming a tedious job using the relational databases’ approach. Can anybody suggest an alternate option if any or way to customize the full text search ? ...
Hi, I have two problems in emacs. First. How do I set-justification-full for the whole document? I can do M-X set-justification-full for a region successfully, but I would like to make it work in the whole document. Second. How do I manage not to get lines jumping from one place to another when I have done set-justification-full, and...
Hi there! I have a Full and Lite applications that were built from the same code. Lite version has a button Upgrade. What code I should place in button's handler for checking users payment and update application to Full version?? I know StoreKit framework that allow to unblock some features, but I need just 2 different applications. Ma...
Hello, Following a question posted here about how I can increase the speed on one of my SQL Search methods, I was advised to update my table to make use of Full Text Search. This is what I have now done, using Gist indexes to make searching faster. On some of the "plain" queries I have noticed a marked increase which I am very happy abo...