i am trying to create indexes on a sql server 6.5 database from an asp page but i am getting the following error:
CREATE INDEX
--------------
Expected end of statement
The create table, drop table and insert into statements are working OK, my statement looks like:
CREATE INDEX idx_trigraph ON x_static_measures (trigraph);
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?
I have these two pages on root directory on the serverhow do i tell the server which one to pick up, or will the browser pick up the .html by default or do i have to manually configure it to do so?
View Replies View RelatedHere's what my code looks like...
View Replies View RelatedI've seen in many websites that they have an index file and everylink shows a diffrent content like
http://www.mywebsite/index.asp?ArticlId=16CatagoryId=18
how can use the same index and call to a diffrent content. i tried to use the include function but didn't work.
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...
We would like an index of our documents and graphics.
They are stored on an IIS 5.0, Win2000 webserver.
Rather than the generic listing of documents, we would
like to show thumbprints.
I’ve been busy converting my website's static pages to ASP pages. I ran into one problem. Currently there is an index.html and an index.asp in the www directory. When I delete the index.html file, I would expect the site to default to index.asp, but instead I get an error message.
Directory Listing Denied
This Virtual Directory does not allow contents to be listed.
This is the procedure I’ve used for PHP sites, but maybe there is a different rule I’m not familiar with
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?
View Replies View RelatedWhile reading a article i came accross this word "index server"?
what does this all about?
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
View Replies View RelatedI 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.
i hv one js file for menu bar ..it create dhtml menu bar dropdown with multilisting...it work on my normal html file but if i applied on asp file where i hv dynemic select box then it breaked & my menu doesn't seen me on that list box but on other area it works....if i had put normal form list box then it runing properly.
View Replies View Relatedwhether I can get market indices like DOW, NASDAQ, FTSE and diplay them in a webpage? They don't have to be real time but around half to an hour delay.
View Replies View Relatedis it possible to iterate through a recordset with an index? Something like
while NOT rs.EOF
response.write rs[0]
response.write rs[1]
response.write rs[2]
wend
What I want to achieve is the following. When I am placed on a record, then I
want to retrieve the next and prev record of the current one. Can somebody tell me
how I can do this?
I'm using "POST" vs "GET" because the string is so long, but I'm wondering if the string is to long even for "POST". Code:
View Replies View RelatedI'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 have written a search logic for my website using microsoft indexing
service. I designed it on Windows XP. It works great.
Then i copied that to our Windows NT webserver and it is giving me the
following error
Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object
/search.asp, line 25
Line 25 is
Set QueryObj = Server.CreateObject("IXSSO.Query")
Does anyone know anything abot Index Server ... The Documentation is Terrible and I am trying to find out if you can query the DocTitle.
View Replies View RelatedFor Each keyb In Request.Form
If Left(keyb, 15)="excelFieldName_" Then
'Response.Write(Request.Form(keyb) & "<br />")
ReDim Preserve arrExcel(myCounterb)
arrExcel(myCounterb) = Request.Form(keyb)
myCounterb = myCounterb+1
End If
Next
I am able to get the values in the arrExcel array with the code below...
for each item in arrExcel if item <> "None" then
Response.Write item
Response.Write("<br>")
End if
Next
What I would like is to get the index of the item I have found from the array. I then need to get the corresponding index from another array.
I tried item.getIndex, but that does not work ..
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.
The code below takes the script name of a page (which is always an asp file) and substitutes the asp extension with html and then inserts the file in the <frame> tag.
This code works file for a url such as www.somesite.com/file.asp But if the url includes an index eg www.somesite.com/file.asp#position1 how do I get the #position1 added to the file name that is used in the <frame> tag? Is there a server variable for # info? Code:
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>
but then .
We have Old FoxPro 2.6 based system, which usage Indexing techniq' for fast searching. As now we are developing New Web basesd system in ASP/ASP.net, the time we update the databases which Usage Index. the data dont get reflected in the FoxPro Application.
let me explain. The data updated from ASP pages can be accessed from ASP but they can not be accessed by FoxPro system without Reindexing the table in Exclusive mode.
Is it possible to use a string to index an array rather than a number? Eg
myArray(lets) = "hello"
myArray(uses) = "goodbye"
myAray(words) = "something"
Response.Write(myArray(hello)) gives 'hello' .
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.
I have a membership application on my site, running off Access database with asp. It has been working fine, made a couple of changes and now all kinds of trouble have broken loose! I have even re-uploaded original files back up, but I am still getting the below error:
"Microsoft JET Database Engine error '80004005'
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
/login/user.asp, line 345"
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 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?
View Replies View Relatedwe use the indexserver to index serveral files on the files server witch are then searchable thru our intranet. All of that works fine, but the indexserver get the local path to the files witch is E:datenpath ofile.doc for instance. There is an option for getting a relative path, but that just throws out the path to the form that we use to search the katalog. how would i go about changing the above path from file://e:datenpath ofile.doc to file://n:path ofile.doc?
View Replies View Related