i am developing a search engine(ASP with SQL SERVER) for my project . My objective is to search for a data and it should display the result and highlighting the search text in different color. But when i use the search text with more than one word, the result is highlighting only the last word of the search text.
Example - If i search for "Opal" , the search result highlighting all the words with "opal", But when is search "Opal Service", the search result is highlighting only the "service".
Here the "Opal" and "service" are different identities, i will search these two words with AND condition . Code:
Does anyone use a funtion to highlight search terms (if they have a search facility on their site). Basically, I would be sending the search terms from a form field into a results page.
If there are results I would like the search terms to be highlighted. One problem that I could think while using "replace" is that capitalisation would not be maintained.
I have a simple script which boiled down to highlighting search terms... Code:
if Trim(Request.QueryString("search"))<>"" then cont = Replace(cont,Request.QueryString("search"),"<span style=""background-color:#ff0"">"&Request.QueryString("search")&"</span>",1,-1,1) end if
this worked fine, however if the string I was searching was within an <a> tag, the inevitable would happen and an error would come up. I was wondering if anyone knows a way or if there is a script readily available to tackle this issue?
I am doing search application in ASP. I want to highlight the matched text in the search result, for that operation I am using the following function Code:
i want to have a search application wherein it returns a results page and arranged based on the most relevant word. can you please give me an idea with this or point me to any info.
i am trying to make a search/result page(using asp, dreamweaver,iis,winnt,miscrosoft access database) wherein the results page brings up the most relevant words or phrases and not in alphabetical order.
we have a MSAccess database of products with titles, short descriptions, long descriotions, bulletpoints etc contained for each product. we currently search the database looking for the target keyphrase within the fields, but this doesnt give any accurate results as for example a product that is compativle with "widget 1" is shown before "widget 1" . anyone know of a process that will give us better, more relevant search results?
I am in the process of making a new frontpage for the site and i would like to have some new links on there. However with the site been .asp based as its an online store im unable to link to a specific product range.
I would like to know if it is possible to make a link to include a specific search string so that it will display the information that would be displayed if a user had typed this in on the search bar of the site.
For example i would like to make a link that displayed the results for "black shoes" exactly as it would return if a user had typed this into the search bar.
I have created a search page which has a text field and button to search.When searching, if you dont enter anything into the text field, you get no results. I would prefer that everything in the database shows rather than nothing. I am told that if you enter '%' into the text field everything will come up. But how would I make this happen automaticaly rather than the person searching typing this in every time?
Text field code: <input name="keywordSearch" type="text" id="keywordSearch">
I want to create a search form on my site using ASP, it will search through the database and return many many records. But I don't want ALL those records to be shown on ONE page, I want them to be "splitted" up to many pages, about 10-20 records per page. You know, just like any MP3 sites or Soft sites. Is there any one can help me to solve this problem? Or you can show me a link to another location which can show me a way.
I use ASP to display links to Word documents on an intranet. Is there a way in ASP to do text searches on the documents' contents? I want the results to have the link to the Word document plus two or three lines from the document that include the search terms.
im working on a script which will search the specified keyword within files, for this im using FileSystemObject which is working file with html/text/asp files but is there any way to search the text within .doc/.pdf files too?
I have developed a website with ASP.NET Jscript. Im fairly new to development so i used DreamweaverMX and Webmatrix which was very useful. Now I want to enhance it further by adding a search facility into my website and thus providing users to actually find contents within my webpages and display the same.
I have one TEXT file that I use to log download information from website. The file will have unique Login ID for the downloads. When the user will come for next time for download the LOG entry should go under the same section (same ID number) so for this I need to search the text file for the ID and if the ID is found the program should append the NEW LOG entry to the end of Section. (section mark can be a line of ***** ) (mean just before the ***** line)
I want to search text field and highlight the text. This is the code,
Code:
strText = cstr(Request.form("strText")) strText = uCase(strText) strTextWhere = "" strTextWhere = " and (Specialisation like '%"&strText&"%') "
I have a lot of data in different cases. I can do the search, let say i want to search by keyword project, it will display all the "project", "Project" and "PROJECT". But now i can only hightlight the "PROJECT" only. I think this is because of ucase(strText). Is there any way for me to highlight all (either lower, upper and mixed cases)?
The Table I am searching is called 'Items' and the Field I am searching is called 'Item Title'
My search sql string is as follows:
strSQL = "Select * From Items WHERE Item Title LIKE '%var2%'"
However I keep getting the following error message:
Microsoft OLE DB Provider for ODBC Driverserror '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Item Title LIKE '%var2%''. /showroom/asp/showroomSearch.asp, line 45
Is this error being caused by the fact that the field I am searching has a space in the name? If not, please can someone tell me where I am going wrong as this code seems correct to me.
For example: The text to be searched is the following:
Text 1: Hello world! what a nice day today. But I like to sit in front of computer and doing some web design. Now I have encountered some technical problems and would like to get some helps from the experts.
Text 2:
I like fishing.
Text 3: Baseball season is over.
Text 4: The winter snow storm is coming.
Search Keyword: snow. Search result is Text 4
Search Keyword: I Search result is Text1 and Text2
At the end, the key word should highlighted with a different color in the paragraph.
I trying to search a text file using a boolean AND search. What i want to happen is when a user types in type values to search e.g. Name Department (Taylor marketing) i want it to only read out the lines which contain both values.
At present it reads out all lines with Taylor in and all lines with marketing. The code i have so far is: Code:
I have to make a site search function for my website. User types a keyword, and the search function searches through all the static pages for the keyword. The result of the search has to display the URL relating to the keyword, which the user can click to read the contents.
I had no idea how to go about doing it, finally I thought of using a textfile containing the word, and its related URL in the format: Code:
I've created a little search engine that works fine, but I want to highlight the keywords in an article. Using the replace function is OK, but its not very good when covering different cases. Its fine on single word searches but no good with multiple words. eg. if I search for "dog", I can do a replacement on "dog", "DOG" and "Dog" using the replace function. If I was to search for "black dog", I need to cover all possible variants. ("Black Dog", "BLACK DOG", "black dog", "Black dog", "black Dog") Is there any way of getting this to work?
Ive created a web page that queries a db and i have that all working fine. What i dont have though and would like to be able to do is get the page to highlight rows according to one colums value, ie
Colum1 Colum2 Row 1 50 Test <-- would like to the be highlihted lite blue for instance Row 2 90 Test2 <-- would like this to be highlighted red for instance
I have a SQL query that produces a table which displays account numbers and the amount owed on those accounts.
the page that displays that table is written with ASP. Does anyone know how can I highlight the rows in the table where account numbers have more than 7500 dollars in amount owed? Code:
i am working on an application...where i have to search for a string in the database field or text files.when the search finds the string i want it to be highlighted when it showas the result on the asp page.
eg: iam searching for a skill in the resumes...take JAVA...i want the resulting resume on the asp page with the JAVA string highlighted
I have setup a simple site in which users input data to an access database, and then the database results are shown on another page in a table. One of the fields in the databse is Date Added, using the date/time data type.
I would like the table to show new results with a different background colour for a period of time, say one week? Code: