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 am currently learning ASP.I wanted to write a search code like the format i attached with this post, using ASP And MS Access database.I don't even know where to start and how to start. If anybody have any sample script like this,please send to me.
I have an Access db with a table which contains some fields. I have also created a page in which I have created a form with textfields, listmenus, radio buttons and checkboxes. I would like to pass the values from the form in another asp page in which I will retrieve the records according to the selections made in the form.
If I select all the form fields it works great but if I want to select only two or one field I get nothing. That is because in the SELECT code I have used AND...AND.... Is it possible with if statements to avoid this problem?
Does anyone know of a function (preferably already made) that would replace a string starting from it's start position to it's end position with a specific string...
i have a site that shows my dvd collection i have this call from the database and i want to add a search function in the same page (not the datbase) so when someone wants to search for say "Shrek" it will bring up the search results on the main page and should show "shrek 1 and shrek 2" , Also in the same light if someone searches by Actor all the films that actor has been in will appear on the main page
I have created the Form Form in Dreamweaver Code:
<form name="form1" method="post" action=""SELECT * FROM movies WHERE title = " & request("q") & ";""> <input type="text" name="textfield"> Search </form>
Does anyone know of a tutorial or other source that addresses the following problem: I have a textbox (txtSearch) and a drop down box.I want to enter text in the textbox, and then select the table column to search using the drop down box i.e.
I have a page where I enter a keyword and I search for that keyword in my database. I want to highlight the word that is/was searched for in the results. My results consists of values out of varchar and text fields.
i have numerous tables to search through for a 'site search'. some of the searchble fields have html embeded within so after some quick referencing, saw I can use the regExp function to strip out all the HTML leaving only the raw text.
what is the best method to remove alot of words such as "a", "and", "I", "so", "that", "this" ...etc ... from the search string leaving only keywords essentially per page/field that will be searched within for the occurance of the users' input text through a input field. The idea being to only return the suitable records without alot of rubbish.
I have a asp/mysql real estate site that someone else created and I don't know much about asp. If you view all the homes listed on the site you get all the listings which is now 4 pages and growing http://arizonarenttoown.com/homes.asp There is no sort or search capabilities so the list is too long and needs to searched by city.
I have some real estate websites that I created with a open source script, open -realty.org. They are php & mysql and have search pages so I can easily create a link for each city. When the link is clicked a search page displays only listings for that particular city. Code:
I would like my ASP-based site to have a search box to bring up a list of relevant pages according to user-defined search criteria.
Q: Do I need to have a d/b like SQL Server 7 at the back end to process and match the search string? Or can I do w/out a d/b somehow and run a search, and somehow still bring up the same results?
If a d/b isn't necc, pls. advise on webpages where I can find such ASP-search codes.... TQ!!
i want to do a search function for my project, my project is allow user to upload file into my server and sharing among each other,i need to do a search engine function to allow user to search for the file that they want, can i know there a function can search through the server's file implemented in asp?or may i know there any open source search engine function coding for me to refer?
I have a page that uses the data from the previous pages form to search the data in the database and dispaly any matching results.
On doing so i get this error:
Error Type: Microsoft VBScript compilation (0x800A03F9) Expected 'Then' /IT/searchresults.asp, line 20, column 15 If Request.Form"(Typesearch") = "computer_name" Then
I have a neat database running and im trying to place a search engine thro it. I have quite a few tables, BUT i can only get the query in one table. ie Code:
I have an asp form that customers use to place orders with us. As I'm sure alot of you are in the habbit of hitting the enter button when you are filling out forms instead of the TAB button (I'm this person also) and having it submit the data before you are done.
Is there a way to use the "enter key" to advance to the next form box ?
I need to make a form in which if the user selects 'NO' on a radiobutton, that the form will take him 4 or 5 questions down...and if possible maybe disable the ones it skipped?
I've recently made a recursive sub in asp to search all folder and subfolders of the map "file" for a certain filename. It will list all results and show a link.
Now there's still a bug. I can't place files in the root because this script won't find 'em. The root i mean files.
If i replace the empty dir with Server.MapPath("") it will show the files in the root but it will show 'em twice. Code:
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.
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 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)?
i want to have alert for my delete process. but I have no idea how to call my function in this case. this is the text.
<a href="padamlaporan.asp?idl=<%=id_laporan%>&i=<%=request("i")%>">Padam Laporan</a> i want to call this function.
function padambutirlaporan(){ if (confirm('Adakah anda pasti untuk padam laporan ini?')){ document.location.href = "padambutirlaporan.asp?idl=<%=id_laporan%>&i=<%=request("i")%>";
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.
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:
