Hello! I am creating a small search function on my site, this enables the search for articles in the system. Each article has a set of keywords associated to it and these keywords are stored inside a SQL Server database. This is the table: CREATE TABLE [dbo].[SearchWords] ( [ID] [int] IDENTITY(1,1) NOT NULL, [ArticleID] [int] ...
I have a social network set up and via an api I want to search the entries. The database of the social network is mysql. I want the search to return results in the following format: Results that match the query AND are friends of the user performing the search should be prioritized over results that simply match the query. So can this...
how can i index acronyms like 'm.i.a.'? when i search for 'mia', i get results for 'mia' and not 'm.i.a.'. when i search for 'm.i.a.', i get nothing at all. edit: solution looks roughly like: ignore_chars = -, . ...
Say there is a spreadsheet or table in MS access which contains non English characters (diacritics) such as à, á, â, ã, ä, å, æ, ç, è, é, ê, ë Since this system is used by English speakers, the end-user, when searching for values cannot guess whether or not certain words or names were entered in the English version or in the original ve...
Hello Guys, I just wanted to ask is there an easier way to get records from all tables of db using a single query where some tables are linked using PKs and FKs. For example, i have a drop down which has 'Cars', 'Bikes', 'Trucks', etc When I select Cars, i get results only from the Cars table. But now i have added 'All' to that drop ...
I've got a huge file (500 MB) that is organized like this: <link type="1-1" xtargets="1;1"> <s1>bunch of text here</s1> <s2>some more here</s2> </link> <link type="1-1" xtargets="1;1"> <s1>bunch of text here</s1> <s2>some more here</s2> </link> <link type="1-1" xtargets="1;1"> <s1>bunch of text here</s1> <s2>some...
I have a quick question i hope you guys can answer, i've got a search system that uses POST to do searches, now i want to track queries using Google Analytics but it requires using GET url parameters to pull parameters out the URL, what i don't want to do is rewrite the entire search system to use GET instead of POST. Is there any way ar...
I have the following search phrase and I need to extract ABC XYZ Mobile Accessories Samsung 250 whenever they occur in the string in any order. The application is C# .Net. Search Phrase __________________________________________________________ ABC XYZ ABC XYZ category:"Mobile Accessories" category:"Mobile Accessories" ABC XYZ A...
Hi all, on android i have big listview which has to support filtering. For now my implementation is the following. EditText and TextWatcher to listen for text changes. All data is stored in db and when there is event for TextChange fetch a cursor and set new CursorAdapter to the listview. I use AsyncTask to query the db and to update t...
We see Google, Firefox some AJAX pages shows up list of probable items while user types characters. Can someone give good algorithm,datastructure for implementing autocomplete ? ...
Hi, We have a fairly large disk array with roughly 2-3 million XML files on it. The disk is formatted with NTFS and we would like to search the filesystem using wildcards. So something like * SomePartOfTheFilename * would be a typical search query. We are using .Net and are finding that using DirectoryInfo appears to be slow. Director...
We are experiencing an issue where a FullTextSqlQuery is only returning the default 100 results whenever certain criteria are added in the WHERE clause. We are setting the RowLimit to int.MaxValue, and when a wide-open search is done, we are receiving the max results. It's only an issue when tacking-on CONTAINS clauses. Has anyone els...
I dont want the default results that SharePoint returns. I want the query term when entered into SharePoint search box to be redirected to a different search engine? Can I do that. I have seen FAST ESP web parts but could not figure out how they actually transferred the query to FAST search engine. Any help would be really appreciated!...
Is there a way to search for folders/projects by name in the Eclipse workspace? The results would best be returned in a view where I can do bulk operations (like closing, opening, assign working set). It's just to fiddly to manually click through the list of hundreds of projects. This seemingly trivial task is causing grief to me, w...
OK. I am using the C# programming language to access a simple database (on Microsoft SQL Server) Currently, I am using the DataReader object to access the database. So here is my question: is it possible to do a binary search (in C#) for a particular piece of data so that i can make the search faster? Currently, I'm using a simple whil...
Some databases (e.g. Scopus and Web of Science) implement proximity operators such as SAME or NEAR. With these the user can define that he wants his search words to be within a set number of words from each other or in the same sentence or paragraph. I just started wondering how this is implemented. Full-text search as is is not that co...
Hi, I have a website that has product names containing French and English words. When I store a product name I store it as html encoded in the ProductName field in my SQL Server. For example the word Château is stored as Ch& #226;teau in my database. If someone wants to search for a product name I htmlencode the search term. This will ...
I'm looking for a way to parse some user-input. The input should show which searches have to be performed and how they have to be combined. 1 AND 2 (3 AND 2) OR 1 (3 AND 2) OR (1 AND 4) ( (3 OR 4) AND 1) OR 2 etc. The first example should combine the results of search 1 and 2 in an AND-fashion. The second example should combine the r...
How do I extract a list of the URLs for a Google Search results page? ...
I want to search some text and move the entire line where the text belongs to the beginning of the file. Just that. ...