I'm trying to make a searching tool in my web site that will search in one table in database
What i want to do is to search by three columns and shows the result if the string found in one of this three columns, so here what i tried to and its not working okay, coz sometimes it works and other not while entering correct string
string Search = Request.QueryString["s"].ToString();
string Sql = "SELECT * FROM Topics WHERE TopicName LIKE '% " + Search + " %' OR";
Sql += " TopicIntro LIKE '% " + Search + " %' OR TopicBody LIKE '% " + Search + " %'";
I also wanna know how to remove quotations and other stuff that shows error message if entered in the TextBox
Thank you alot
Hi! Maybe I ask simple question. But for me it’s not so. The matter’s I plan organize search at my website. It has catalog of firm’s and good’s in SQL Server. I plan to build dictionary table with two fields’ search_item and link. But problem is that I should put all search variant’s in field search_item(name of firm, name of boss, name of good etc.) Maybe there’s another concept to build search? Thank’s for any answer.
I am building a front-end search on a website to serach through thecontents of a full-text enabled databsae. I have everything set-up andworking using FREETEXTTABLE.Here is what I want to do. When a user types in a search phrase thathas a couple words in quotes, I want it to do an AND for those insteadof the normal OR that freetexttable seems to do. Is there somethingbuilt into SQL Server that can handle this or do I need to parse thephrase myself and build up some sort of logical operation with thewords and a combination of AND's and OR's. Has anyone done this orhave freeware that handles it or any suggestions at all.Thanks in advance for any help.
How to implement a universal search in my site And it must be give result precised up to 90%.
Scenario is like that whenever customer come to our site he/she can search for example: Car parts
My Table structure is like below:
Column 1 Column 2 Column 3 Column 4 column 5 column 6 (Keyword) Toyota camry 2000 wheel ABC123 Toyota camry 2000 wheel abc123 Toyota camry 2000 wheel cover 123 Toyota camry 2000 wheel cover 123
Now i have created a full text search index on column 6(keyword)
so whenever someone search exactly describe in column 6 it gives result
For ex: if i search (Toyota Camry wheel) with CONTAINS Option
Select * from mytable where Contains (Keyword,'Toyota and Camry and wheel')
It gives me rows which contains Toyota Camry wheel and other rows which having wheel cover also. So i get multiple rows. Because of we have very large table which contains data in millions its not to feasible to have that thing.
another thing is :
if i search (Toyota Camry wheels) with CONTAINS Option Select * from mytable where Contains (Keyword,'Toyota and Camry and wheels')
It won't give any result back to me which is embarrassment for me. Because customer can search anything so if its not giving result its bad impression.
Also i tried to use FREETEXT option but it gives result in combination of all this word which i searched. so its huge amount of data in result.
Hi - I'm short of SQL experience and hacking my way through creating a simple search feature for a personal project. I would be very grateful if anyone could help me out with writing a stored procedure. Problem: I have two tables with three columns indexed for full-text search. So far I have been able to successfully execute the following query returning matching row ids: dbo.Search_Articles @searchText varchar(150) AS SELECT ArticleID FROM articles WHERE CONTAINS(Description, @searchText) OR CONTAINS(Title, @searchText) UNION SELECT ArticleID FROM article_pages WHERE CONTAINS(Text, @searchText); RETURN This returns the ArticleID for any articles or article_pages records where there is a text match. I ultimately need the stored procedure to return all columns from the articles table for matches and not just the StoryID. Seems like maybe I should try using some kind of JOIN on the result of the UNION above and the articles table? But I have so far been unable to figure out how to do this as I can't seem to declare a name for the result table of the UNION above. Perhaps there is another more eloquent solution? Thanks! Peter
Our clients want to be able to do full text search with a single letter. (Is the name Newton, Nathan, Nick?, Is the ID N1, N2...). Doing a single character full text search on a table work 25 out of 26 times. The letter that doesn't work is 'n'. the WHERE clause CONTAINS(full_text_field, ' "n*" ') returns all rows, even rows that have no 'n' in them anywhere. Adding a second letter after the "n" works as expected.
Here is an example
create table TestFullTextSearch ( Id int not null, AllText nvarchar(400) ) create unique index test_tfts on TestFullTextSearch(Id); create fulltext catalog ftcat_tfts;
I have a scenario of where the standard Full-Text search identifies keywords but Semantic Search does not recognize them as keywords. I'm hoping to understand why Semantic Search might not recognize them. The context this is being used in medical terminology and the specific key words I noticed missing right off the bat were medications.
For instance, if I put the following string into a FT indexed table
'J9355 - Trastuzumab (Herceptin)' AND 'J9355 - Trastuzumab emtansine'
The Semantic Search recognized 'Herceptin' and 'Emtansine' but not 'Trastuzumab'
Nor in
'J8999 - Everolimus (Afinitor)'
It did not recognize 'Afinitor' as a keyword.
In all cases the Base of Full-Text did find those keywords and were identifiable using the dmvsys.dm_fts_index_keywords_by_document.It does show the index as having completed.
why certain words might not be picked up while others would be? Could it be a language/dictionary issue? I am using English and accent insensitive settings?
would you use sql server "full text search" feature as your site index? from some reason i can't make index server my site search catalog, and i wonder if the full text is the solution. i think that i wll have to you create new table called some thing like "site text" and i will need to write every text twice- one the the table (let's say "articles table") and one to the text. other wise- there is problems finding the right urlof the text, searching different tables with different columns name and so on... so i thought create site search table, with the columns: id, text, url and to write every thing to this table. but some how ot look the wrong way, that every forum post, every article, album picture or joke will insert twice to the sqr server... what do you think?
I have installed the Adobe iFilter 11 64 bit and set the path to the bin folder. I still cannot find any text from the pdf files. I suspect I am missing something trivial because I don't find much when I Bing for this so it must not be a common problem.Here is the code.
--Adobe iFilter 11 64 bit is installed --The Path variable is set to the bin folder for the Adobe iFilter. --SQL Developer version 64 bit on both Windows 7 and Windows 8. USE master; GO DROP DATABASE FileTableStudy; GO CREATE DATABASE FileTableStudy ON PRIMARY
I have a table that contains words that will be used to search another table where FullText index has been created on searchable columns. I'm basically trying to run something like this:
SELECT t1.col1, t2.col3 FROM tbl1 t1, tbl2 t2 WHERE CONTAINS (t1.col1, t2.col1)
I know this won't work but is there a way to join these two tables so the words (t2.col1) can be passed as search conditions? There is no common key on both tables so normal join won't work. I'm trying to find a way to pass the search words from one table to another.
I have Sql server 2005 SP2. I enabled it for Full Text search. Substring search where i enter *word* doesn't return any row. I have a table testtable where description has word Extinguisher.
If i run a query with *ting* it doesn't return any row. select * from testtable where contains(description,'"*xting*"') ;
But it works if i do select * from testtable where contains(description,'"Exting*"') ;
The Full text search document says it supports substring search. Is it an issue with sql server 2005?Please help.
I am using Sql Server 2014 Express edition.I have a table with a varchar(max) column. I have created a full text search that use the stoplist "system". column has this struct: xxx.yyy.zzz.... where xxx, yyy, zzz... are numbers, like 123.345.123123.366456...I can have rows like that:
select * from Mytable where contains(MyColumn, '123.345.')
I gues the contains would return all the rows with column contains 123.345, but this does not return all the expected rows, only one row.I have tried to replace "." with "-" but the result is the same.I have also tried with '123.345.*. In this case I have got more results, but no all the exptected rows.If I use this query:
select * from MyTable where MyCOlumn like '123.345.%';
Can anyone tell me how to search an SQL database for a given key word in a textbox? I basically have a database that has a qualifications column and this column needs to be searched for the data given in the textbox. Which is the best method to search for the data? Is it a simple SQL query or an XML based search engine type? Can anyone give any suggestions regarding this? If XML is efficient then how do I use it to query my database, as I'm pretty new in XML based searching.Thanks
hi there, i am doing a school project and i need to have this search engine that will search the data that i have stored inside the database and display the results out can anyone help? thanks
My site uses a text box to allow visitors to search products. I'm trying to design the SQL Statement to allow search's on full words, part words, and words/phrases regardless of the order the words are in.
E.g. megger meg mft megger (proper order in the database is megger mft) mft1710 (using 1710 should find the product)
This is my select statement (classic ASP)
Code: <% Dim RSResults__param5 RSResults__param5 = "xxx" If (Request("searchme") <> "") Then RSResults__param5 = Request("searchme") End If
HelloI am getting this err msg when trying to logon to my website on the web - on my machine there is no prob, An error occurred while established a connection to the server.When connection to Sql.S 2005, this failure may be caused by the fact thatunder the default settings sql.s doesn't allow remote connection.(provider :Sql.S Network interface, error:26- Error Location Server/Interface Specified)(the files path is like in the web host s)
Hi everyone. This is my first post here. I did a quick search and didn't find what I as looking for, so I'm hoping you all can help me.
I'm working on a project that will allow my company to upload images to a database and have the website pull the images from the DB. We are planning to incorporate some type of cacheing, however I'm skeptical as to if it is really necessary. I imagine that I'm certianly not the first to do this and I'm wondering if someone can let me know if I truly should expect a performance hit, or if I shouldn't really worry about it b/c this is a very common mantra.
Thanks all. I've been pretty vague and haven't explained all of the details. I can write more, but I'm just looking for generalizations right now.
I am new to .NET and the Visual Web Developer Express and what not...I have created a website on my machine which works wonderfully...however, and I'm sure this is somewhere but I can't find it, I cannot get it to work on my host server...the Default page comes up, but when I try to sign in it says: "An attempt to attach an auto-named database for file c:hostingwebhost4lifememberharrison0801App_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share." The host support tells me to change the db name from aspnetdb to something else...I do this and when I run the site again or try to log in, I get the exact same error message...then they go on to tell me that I have to remove the LocalSqlServer in the web.config file which now looks like this: <connectionStrings> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=.SQLEXPRESS;Integrated Security=True;AttachDbFilename=|DataDirectory|aspnetdb.mdf;User instance=true;" providerName="System.Data.SqlClient" /> <add name="Example" connectionString="Data Source=.SQLEXPRESS;Integrated Security=True;AttachDbFilename=|DataDirectory|example.mdf;User instance=true;Initial Catalog=example;" providerName="System.Data.SqlClient" /> </connectionStrings> Of course this isn't working either...otherwise I would off playing on my server, and not posting here. Also, when I set up all the roles, users, and what not on my machine...does this carry over to the host machine? Desperately needing massive help here.... Not a DBA and no expert in .NET Thank you very much in advance, Darren
Hi I want to have a report on a website page that will respond to user input.
Basically a page that will displays requests when the user inputs a user_id; the user will then need to be able to drill down and select a specific request to display and print that request.
It's been a long time since I last experimented with SQL Server (2001) so I am not sure of new product features or developer techniques.
A client of mine is wanting to deploy an E-Commerce website and one if the core requirement is that the site must integrate with his internal MS SQL Database i.e. Orders placed online must be seamlessly entered into his internal Sales database. Ideally this would not require any re-keying or daily batch imports.
Many web hosts offer SQL hosting so how (if it is possible) could I link the hosted database to the internal database?
I have a web page where my users are selecting a bunch of filters to generate a report. The page then pulls the initial data from the database, applies some adjustments to the records, and then puts the data in a temporary table for that user. I want to create a report template (or a report saved on the report server) for this report. I want to use the same report for each user but be able to change the datasource for the report on the fly for the current user's temp table in my webpage before displaying the report. Is this possible?
Ok, I have this up and running thanks to the help of lots of users in this forum (Thank You again)
I deployed some reports, and everything looks fine, however to add another twist to this, I would like the website to look prettier, by adding something like a welcome page,and some folders and such.
Does anyone have any ideas on how to do that ??? DO you have any material or a website, where I can get some info ??
