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?
Im searching a database and pulling through results based on user input with a like statement as the address have multiple words but the problem is i want the search only to be in whole words and not part of another word for example User searches road
Results:
Some Road Another Road Broad Lane
simple search using select address from tblName where address like % searchterm %
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 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:
I have to put some terms and conditions on my commercial site which vendors have to accept before going into site. My query is in practice how you people do it? I mean do you store these information in database ,or do you keep time stamping in database,or just force users to read and accept it without saving . I know it varies company to company ,i asked generally.
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 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 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:
The very same page has 2 iFrames opening another page called tripledemoduo.asp. So there are 2 tripledemoduo.asp's opening within the 2 iFrames. Within a tripledemoduo.asp page there are the textboxes for inserting the keywords. See the picture.
is it possible to move out the 6 textboxes from the iFrames and make 1 set of 6 instead of 2 sets of 6? That would make my life easier because I use this to compare two texts side by side by searching keywords. For example I put one keyword in red in both iFrames.
i get the ref url that come to my site and i want to convert it to find out what was the query in (google or other searcher sites)
foe example : if someone goes to google and search some text and my site was in his resaults and he click on it , in my site i see his link ref like http://www.google.co.il/search?hl=i...91-Google&meta=
i want to know (in asp and save it to DB) what was the word or words that the user write in search engine.
I am trying to create a parametric search within a table (in the column headings). My first page (search.asp) allows you to choose parameters from a dropdown box, such as package and volts. You click "search" and it reads the Access dbase to yield the results.
The results page (results.asp) displays the information based on the parameters. Under the package column heading, I have the same drop down box, and I am able to once again choose the package I want and the table will refresh. Code:
I have list of songs in table in asp page. I would like to put a link to each song so when user click on one I can search database for it's data. How to do that?
i have a database with 5 tables, on my web site i have a search bar.. i wana link that search bar to my tables so.. when ever some 1 searchs for a product, the search bar shows that all the simmuler products to what they searchd for..
I have a search page that has ms frontpage database wizard results showing. The thing is, is that I want to have the search form on other pages besides my search.asp page. Does anybody know how to make a search form on a seperate page that submits the search to the database and displays the wizard results on the search page.
How could I try and make the most important result from a search show up on top? I was thinking of having a result where the strSearch is the most to the left come up on top but else then that vague and not necessarly effective option I have no idea on how to do this.
Intranet tech support system using ASP/VBScript running on W2000 Server, IIS, and using SQL Server 2000. I need to add a search engine. The problem with using a regular SQL query is that if you put a phrase, say "red car" in the text box, to hit submit, my SQL qurey would only look for that phrase, and would leave out other items where the words red and car appeared separately. I guess what I am saying is that I would like something like Google or other search engines, which would find results which seem to fit the criteria typed into the box, and rank them and highlight key words. My research so far has shown me that SQL Server has something called Full-Text searching, and I have tried to read up on that in BOL, but not really seeing how I can apply it. I wonder if there's already some tutorials or sample code out there. I have done some looking on the Web, but still haven't found much.
I have created an asp server page as described in the Microsoft Article 318387 HOW TO: Query Index Server Data by Using ASP in FrontPage 2002 (http://support.microsoft.com/?id=318387)
It is running off my IIS server for the search results. However, the results return only file locations; I would like it to return a link to the hits. How would I do this?
im now doin a search function... but my problem is... if i didn't enter any data in the textbox and then click search button, it will appear all list from database instead of display "please key in data".
I just want to display "please key in data" but not display all records. Code:
I am trying to set up a pge that allows users to search DB for their order status. I managed to get it working with 1 search parameter. I would like to give my clients more then 1 search option to search by.
This is where I ran into problem. I believe it to be with my lack of ASP knowledge and the problem here is with the SQL statement. I do not think that it will work the way SQL statement is set up right now but I am at a loss for correct syntax here. Am I way off ? Code:
I am relatively new to asp so still need help on it. On my site I have a search that allows users to search for a specific job skill ie.cobol, asp etc
The problem is that at the moment the search can only search for what is exactly typed in the box eg.
"ASP" this search works fine, "ASP, HTML" this doesnt because It searches for what is typed in. I have been told It is something to do with parsing and that this will allow me to search for multiple job skills using commas to split what is typed in. If any body has any ideas I will be very greatfull