I have a site set up that is used for researchers to submit abstracts of their research. It is saved in a Access2k db and then admins can get at the abstract, organize them and then we have a research forum where judges, well they judge the research and give out awards.
This year we wanted to try to enable a "search abstracts" function that would allow people to search on keywords in the body and title of the abstracts.
Does anyone have any info on the best way to implement this so that I can order by largest number of word matches from the search string and such? I am hoping to now have to rewrite the db as it stands.
Right now there is a text field for the title, and a memo field for the abstract. It includes html code (from editize). I can always search by sql, I guess the hard part is making an intelligent search. Any tut's or examples?
I'm having bit of a problem with a search engine. I got an intranet running in a company with IIS, Indexing Server and ASP. I've realized a search engine which also returns abstracts from the documents.
Most pages in the website are ASP pages. That doesn't mean that it draws all its contents from databases. I'm using ASP for other stuff as well. So they're basically documents, but with extras and hence ASP.
I excluded all sorts of things, e.g. "_" directories, like _vti and _private. Also directories like "include" are left out as people don't need to search for javascript code or css style sheets. Those are not relevant to the users. And finally I also give people the opportunity to make files non-searchable with a quick tag.
So what's the problem? When I perform a search e.g. for "body" (without the "" quotes) it would in this example return some results and one of those results got an abstract with evident pieces of ASP code. Code:
We've had Index Server 2.0 running on an NT4/IIS4 server for several months now. It generates document abstracts and we retreive and display them using ASP/VBScript and ADO, using the SQL-querying method rather than the proprietary Index Server objects.
We're now trying to set up a replacement server based on Index Server 3.0 and Win2000/IIS5. We have the system up and running as before, with the exception of the abstracts.
Nothing is being returned for the abstracts - no data, no error message. "Generate Abstracts" is ticked in the Catalog Properties and we've ordered any number of re-scans and Stop/Starts of the service, but we're still not seeing any abstracts.
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
I have a column in my database where emails are copied to, and i need to be able to search through each entry for certain keywords and display the results if the column contains any of the keywords. i can't figure out how to do this though, because if i use the select statement like this:
select * from maintable where column LIKE ('keyword') or select * from maintable where column IN ('keyword')
it will only display the results when the keyword is the only word in the field.
I'm producing a search that when a section is chosen from a drop down menu the search only searches the selected section. The problem is the code below searches others sections as well as the selected one.
strSQL = "SELECT * FROM qry_Policies WHERE SectionID = " & request.Form("section") & " AND title like'" & txtSearch & "' or keywords like '%" & txtSearch & "' OR keywords like '" & txtSearch & "%' OR keywords like '%" & txtSearch & "%' AND '" & txtSearch & "' OR title like '%" & txtSearch & "' OR title like '" & txtSearch & "%' OR title like '%" & txtSearch & "%' ORDER by title" .
It may be a really stupid question, but if you dont ask, you dont know. Is it possible to search an an xml file, which is used for an RSS feed, with asp at all? So for example, i want to have a search box on my site, which will then search the xml file for the search term, and then return the result to the person searcing?
I'm producing a search that when a section is chosen from a drop down menu the search only searches the selected section. The problem is the code below searches others sections as well as the selected one.
strSQL = "SELECT * FROM qry_Policies WHERE SectionID = " & request.Form("section") & " AND title like'" & txtSearch & "' or keywords like '%" & txtSearch & "' OR keywords like '" & txtSearch & "%' OR keywords like '%" & txtSearch & "%' AND '" & txtSearch & "' OR title like '%" & txtSearch & "' OR title like '" & txtSearch & "%' OR title like '%" & txtSearch & "%' ORDER by title"
I'm developing a site search engine and I need to have it be able to search through PDF documents also. Being a novice programmer, can anyone help me out with this?
My company's website has a search feature, and we would like it to search using multiple words instead of finding exact phrases. If I type Roland Printers, it finds nothing. But some of our titles have both of those words in them.
I've attached a screenshot of the code (I couldn't get it to copy and paste correctly out of dreamweaver).
Does anyone know any good examples of how to code a search within a search. I'm sure there is a correct name for what its called but I don't know what it is.
Basically i want a user to be able to search my datatabse and get say 50 results. I would then like them to be able to then say show 10 items per page or 25.
i'm doin a search engine. when i type " ' in textbox to search ...it appear<input type="text" name="txtSearch" value="" '" size="20" id="txtSearch">, and then my textbox disappear. What's wrong?
City - name of city RentLow - low range of rent RentHigh - high range of rent myquery - keywords
The following is the start of my query string but I am having issues with the City portion already and I have not gotten to the rent yet
I know the SQLquery portion right below is fine - it tested perfectly, along with the rest of the query, it was when I added in the request city string that gives me No value given for one or more required parameters. even though one is passed in the string.
SQLquery = "(" &parsethis(strText ,words ,wCount, 3) & ")" SQLquery = Replace(SQLquery, "<FIELD1>", "title") SQLquery = Replace(SQLquery, "<FIELD2>", "description") SQLquery = Replace(SQLquery, "<FIELD3>", "comments") SQLstr = "SELECT * FROM links WHERE " & SQLquery & " AND city = " & Request.QueryString("city") & " AND linktype = 2 AND active = " & myTrue & " " & SortSQL & ";" end if
I've got a search query that involves a kewyord input that searchs 2 db feilds. It works fine if you use one word searches, but draws no records if you have 2 words. How do I set up a search that can include multiple words or multiple individual letters etc... Code:
I want the ASP code to pull data from the database. If i enter one of the field in the form and then click on Search button, the data for the other fields should automatically pop up.
