Combining Index Server And SQL Server Search Results
I'm just about to start a project that needs to combine the results of a SQL
Server query with the results of an Index Server query. The basic idea is
that the user enters/selects a bunch of search criteria on a form.
Most of
the criteria selected by the user will be used to select records from the
database - standard WHERE clause stuff - but the user can also enter
free-text that should be searched for in associated uploaded documents.
The
documents are sitting in the file-system with file-name pointers only stored
in the database (not the document). Only records where the associated
free-text is found in the documents should be returned. I'm new to Index
Server and am wondering how is this done. Any good references/tutes?
I am having a problem with the following search results code. The first page of results looks normal, but on the second page (records 26+), no results are displayed and the following error message is shown:
“The catalog directory can not be found in the location specified by 'CiCatalog=' in file indexServer.idq.”
I do not understand how the catalog could have changed in between the first and second pages of results. Can anyone tell me what may be wrong? I have attached the search page (search.htm), the query file (indexserver.idq) and the query results template (indexserver.htx).
I have set up Index Server in IIS to search my intranet. I've installed the Adobe PDF filter so that words from PDF files are included.
I can get results from PDFs when querying the catalogue in the Windows console. However, I have tried various ASP Search pages and they all ignore PDF files from a browser (even though the scripts include the pdf extension).
I'm having trouble getting my head around the query language for an Index Server Search w/ASP.I have some dummy content pages that have text like "this file contains things" and "this file contains stuff".I've tried these two queries: PHP Code:
SELECT DocTitle, VPath, Path, Filename, Rank FROM SCOPE('DEEP TRAVERSAL OF "c:inetpubwwwroot"') WHERE ((CONTAINS(' "file contains" ') >0) AND ((Path NOT LIKE '%\_vti%') AND (Path NOT LIKE '%\_private%') AND (Filename NOT LIKE 'search.asp'))) ORDER BY Rank DESC
I am using the Index search server that comes with MS IIS 3.0. The search works ok but how do I limit the search to only HTML/ASP files and not include MS Office files in the search results?
I fire the following code on Index Server (different obj) and it returns a PDFs no problem, but when I change the object to use the MSSearch for Site Server I don't get any PDFs. Anything in the code that would cause this? I can see the PDFs getting crawled in Site Server, but when I try and search I don't get any pdfs .....
I am uploading to a server for the first time. I believe that my server will not point to .asp pages as the start page, only .htm is this correct?
I wanted my index.asp page displayed first from the web-site by default, but have been told that I need say, an index.htm which then points to my index.asp page.
Is there a way that I can use my index.asp page as my start page?
This is partly an ASP question and partly not an ASP question.
I'm trying to implement an ASP page that will use Index Server to provide search capability for a document repository folder. I've gotten this working on my server fine, but I'm now trying to implement it on a laptop (running Windows 2000 Pro) so that a salesman can show it to a prospective client. I was wondering if anyone knew if accessing Index Server through a web page would work on Win2kPro and the PWS it has?
Also, my working version is currently using the old style idq and htx pages and I've been having a hard time finding a good resource to show me how to do this in ASP...
I have to place a search the site text box in my .net site .I have installed MS indexing service and it has indexed my completed folder and if i query it it only shows the fields Rank,filename,Vpath,write ,size its not showing me the description and title which my headache. I am making the query to server : "select description,Contents,DocTitle, Filename, Vpath, Size, Write, Characterization, Rank from scope() where FREETEXT(Contents, 'market') order by rank desc"
I have index server running and happily cataloging one site and dishing up search results via and asp page. Having created a new catalogue for another site and putting the same asp code in I don't seem to have any info in the "characterization" field! Any idea why this is? Is there something about the way the pages are built that would allow that to work or not?
I've been playing around with MS Index Server 3.0 (well, the one that comes with Windows 2000 Professional!) and my client has a website that generates dynamic content based on ASP code. I unfortunately require the use of Index Server because the IFilter allows support for searching within PDF files.My problem is that while all of the static content pages and PDF files are detected, indexed and catalogued fine, none of any dynamic pages are. I can clearly see why this is, since I assume Index Server doesn't have a webcrawler of any sort!I was wondering then, how people generally get around this problem, working with it? What is a quick way to get dynamic content integrated into the search? Should I find/write a webcrawler then put it into my search program or is there something better out there that will let me do all of this
I have a custom search engine for our website that uses MS Index Server and it works great but it doesn't find any results for searches that contain french accented characters.If I'm searching for "élément"...it doesn't find anything because the page uses html codes for accents and this word would be written like
"élément" in my source code. My page uses charset utf-8 but the Index server uses 2 separate files(.htx and .idq files) and there doesn't seem to be any settings in there for this problem.
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 need a search engine for my web. The service Index Server (for web) is started (win 2K) but i don't know how to make an ASP page for that. I can make a form like this:
<form ACTION="/asp/search_v2/query2.asp" METHOD="POST"> <table WIDTH="500" bordercolor="#FFFFFF"> <td>Give what you want to search:</td> </tr> <td><input TYPE="TEXT" NAME="SearchString" SIZE="65" MAXLENGTH="100" VALUE=""></td> <td><input TYPE="SUBMIT" NAME="Action" VALUE="Go"></td> </form>
I'm working on creating a search functionality. I have keywords of articles in one column of a SQL server table, and the search terms of the user is hitting that column.
It works but I'm stuck on how to determine relevancy. I know you can create indexes in SQL server, and if it works anything lik Index Server, I was thinking that I could connect via ADO and determine relevancy.
I am currently in the process of moving my website from an NT Server/IIS 3.0 to a Win 2003 Server/IIS 6.0. I am trying to set up the index server for my site search. I have added the catalog and stored it in the same directory as my current website. I am using the exactly the same code and the same catalog name.
When I use the "Query Catalog" option within the Index Server I get results when I run a search. However, when I run a search through the website I get nothing returned.
We've been using Index Server and IIS4 and the corresponding objects to search our sites. Everything fine.
Now we have set up a new server running IIS6 and the search results always return "null" for Characterization, DocSubject and some other properties. I found out that they were not cached. But turning caching on and initiating a reindex didn't help either. Code runs fine on IIS4.
I've not used Index Server since I set it up about 4 years ago on a Windows NT 4 machine.
I now have to move the site to a Windows 2000 machine. I've hunted high and low and have yet to find anything on the subject. Anyone point me in the right direction?
I was excited to use Microsoft Index Server, built into IIS, to set-up a site-search function, but it doesn't, by default, parse the ASP code of the pages it indexes. This makes it sort of a weak option for a site that uses variables to populate content in a templated site.
For example, I use variables to fill in the meta tags, and every page shows up in the search results as "UNTITLED." The problems go much deeper than that, but that's just an example.
if there's a trick to make it parse the code before it indexes? I mean, it's IIS, right? It should be able to parse ASP code. (You would think.) It seems to know not to index the ASP code, or else the contents of the variables would still be indexed, so it seems like it has the potential to parse the code before indexing.
Following is a vbscript code extract triggered by a combobox OnChange event. arrVendorA and arrdefpack are server side arrays and i need the intCounter parameter to be the array index. Code:
<script> sub getstdPackByVendor(strPartNo, intCounter) dim selVendor selvendor= colSelect("cboVendor", intCounter).value
if selvendor= "<%=arrvendorA(intCounter)%>" then if "<%=arrdefpack(intCounter)%>" = 2 then colTD("txtStdPack" & intcounter+1 ).innertext = cstr("<%=arrVAStdPAckL2(intCounter)%>") end if end if end sub </script>
The following code is giving me a type mismatch error at the 'if' statements... any ideas, anyone ?
sub getstdPackByVendor(strPartNo, intCounter) dim selVendor selvendor= colSelect("cboVendor", intCounter).value
if selvendor= "<%=arrvendorA(" & intCounter & ")%>" then if "<%=arrdefpack(" & intCounter & ")%>" = 2 then colTD("txtStdPack" & intcounter+1 ).innertext = cstr("<%=arrVAStdPAckL2(" & intCounter & ")%>") end if end if end sub
We are looking replace site server's catalog search application. We need to crawl a public website and allow uses to search indexed pages. We need a product to index our site and index custom meta tags we put in our pages. What website crawling products are available in the marketplace?
I have an access database search engine. I am trying to make it resort by clicking on one of the results.
This search engine looks through CDs and returns Title, Artist, Description, Disk Number, Track Number and Price. I would like to be able to click on the disk number and show what all is on that disk. Code:
I have sql server express at my PC-windows xp professional, I try to connect to a table via asp (queryString :"Driver={SQL Server};" &"Server=localhost;" & _ "Database=local;" & "Uid=nikos;" & "Pwd=nikos;" but there is an error Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][DBNETLIB]"The SQL server does not exist or there is no permission.
I can login with EMS lite both with sql server Auth. and windows auth.What is fault?
I'm trying to install a simple e-mail form to my webpage; which takes some info from user (like name, phone, e-mail,etc...) and when user pushes submit button e-mails them to me immediately. I've tried to do so with ASP Formmail but I couldn't succeed. . it gives me: Server object error " 'ASP 0177 : 800401f3' Server.CreateObject Failed " error. Can anyone please help me to install my form? Because I need to install it immediately;
I need to read a SQL Server table into a Web Page and within the Web Page to permit my users to make changes to the records, delete or add new records and then save the entire contents back to the SQL Server table back.
The functionality I am looking is almost the same as In the SQL Enterprise Manager whereby I can choose a table open the table and then return all rows and I can maintain the same and save it back to the SQL Server table. I want almost a similar web interface to such a functionality.
Even if not a generic functionality as the SQL Enterprise Manager table maintenance appreciate if somebody can share the code with a sample how I can do it in ASP pages + T-SQL if need be.
I have created a form that sends email thru my local server. What I want to do is send the email thru our corporate Exchange server. Does anyone know how I can accomplish this task? Please advise. Thanks.
anyone have any tips on creating a search results filter to provide the best matches first? we're using an access database as part of a very small custom CMS, and we need to site search function that doesnt just output any base matches for a given term.
