I have created 3 tables (Products, Catagories, Catagory Index) I use the catagory index to assign products to multiple catagories.I am stuck with the SQL to join the catagory index with the products so I can pull the products out - I have created the relationships,tables are below:
Products
Prodcode (PK)
other fields
Catagories
CatID (PK)
Catname
Catagory Index
ID
ProdID
CatID
as stated I am using the catid to identify the products and would appreciate assistance with the SQL to access the rest of the product data.the CatID is passed to the page via a url parimeter.
For most ASP apps I write, I send out to another server farm. When the tech takes my code and posts it, he usually looks it over to be sure there are no potential security issues. He said to me one day over the phone while uploading the code, "you should use indexing for your record reads..." I just said, "sure, okay." But I have no idea what the heck he meant. Can someone tell me what he meant?~`^%
I have a script to search my site which is written in asp and works with the indexing server in IIS5. The problem I have is that I want to able to specify what directories it needs to search and only search within the region the user is in. There are 2 catalogs in the indexing server and I will be creating a catalog for each region.
I'm trying to set up a pdf search using windows indexing service, but i'm getting the most random results in the world. it's seatching throught a directory of just pdfs, and if i search for pdf, they all come up, but is i search for 103 then 103.pdf wont come up but things like 034.pdf and 29.pdf will - any ideas?! i'm using the windows IISSamples
I've recently transferred our web sites from a Windows2000 server to a Windows2003 server. The transfer went almost flawless until I noticed that our search function isn't working anymore. I'm using an ASP script to use the Indexing Services and have set up my catalogs and directories but I'm getting a 'type mismatch' on one of my Server.URLEncode commands.
Do I need to obtain a new script to utilize the Indexing Services of Windows2003? If so, does anyone know where I can find this or would it be better to use a service such as Google or another SE?
I'm trying to build a site that based on a user entry searches through the contents of files on a disk and displays a list of files which contents match user criteria (basicaly a word).
How to extract a part of the document (paragraph ecc), where the searched word is found. OLE DB provider for Indexing service provides atribute Characterization, which returns the subject of the document, but not the correct paragraph. Is there any other usefull atribute?
I'm fussing around with a first attempt at using IIS6's indexing service for a web site search page. The trouble is, my site, while not using a database, is largely dynamic, with much of the content filled in with variables and includes, and index server only seems to index the actual code of each file, and not the contents as seen by web viewers. So if I have my default.asp file dynamically cobbled together by several other files, default.asp doesn't register in the index with its served content and so doesn't appear in the search results.
Just wondering if indexing service can be used to search pages within a site as they appear to the browsing public (like search engines do), or if it just wasn't made to do that and I should try something else?
For i = startCt To endCt ' Get the document title. If it's blank, set it to "Untitled". Dim docTitle,path,desc Dim tObj Set tObj = results1(i) docTitle = tObj("title") path = tObj("vpath") desc = tObj("desc") .......
Now, results1 comes from the ms indexing server.
Problem with some of the results is the title is an empty string, so no link.
If I query the catalog in comp mgnmt, no problems.
So, indexing problem or something else.
I can use the path and get the doc name there if empty.
I have an Access database driven website using ASP in IIS 6. On my website, I have a discussion forum, I wonder how can I add a full text indexing feature into my forum. So for example, when someone wants to search the word "fish" in the forum. All threads that contains the word "fish" should popup as the search result.
I'm trying to set up a full text search engine on my corp website. Due to the number of documents to be indexed and the strain IS can put on as server, it was determined that the Indexing Services should be run on a dedicated box, instead of on the webserver.
This all makes good sense until I actually try to connect to the catalog in my code. From what I can tell, IIS looks to the local machine for it's catalog sources. Does anyone know if it is even possible to remotely connect to an index catalog?
I've tried adding the server namespace to the catalog name in many different syntaxes, and so far nothing has worked. Code:
I have a problem with a small asp-solution that searches for documents with indexing service. For some files in the search result I get "bad text" returned, such as Code:
