472,328 Members | 1,031 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,328 software developers and data experts.

indexing service

ash
i'm using the indexing service and CreateRecordSet("nonsequential") in asp.......and i cant retrieve the record although the keywords is matched. Does anybody know how to solve it?

thx
Sep 29 '06 #1
8 2346
need to see code
"ash" <as*@gmail.comwrote in message news:%2****************@TK2MSFTNGP03.phx.gbl...
i'm using the indexing service and CreateRecordSet("nonsequential") in asp.......and i cant retrieve the record although the keywords is matched. Does anybody know how to solve it?

thx
Sep 29 '06 #2
ash
<html>
<%
' This section sets the various configuration variables

formscope="/"
pagesize = 5000
maxrecords=5000
searchstring=request.form("searchstring")
catalogtosearch="web"
searchrankorder="rank[d]"
origsearch=searchstring
%>

<%
'This section performs the query

dim q
dim util
set q=server.createobject("ixsso.query")
set util=server.createobject("ixsso.util")
q.query=searchstring
q.catalog=catalogtosearch
q.sortby=searchrankorder
q.columns="doctitle, filename, size, write, rank, directory, path"
q.maxrecords=maxrecords
%>

<%
'This section displays the results

set rs=q.createrecordset("nonsequential")
rs.pagesize=pagesize
response.write"<p>Your search for <b>" & origsearch & "</bproduced "

if rs.recordcount=0 then response.write "no results"
if rs.recordcount=1 then response.write "1 result: "
if rs.recordcount>1 then response.write(rs.recordcount) & " results: "

%>

<table border=1><tr><td><b>Title</b></td><td><b>Filename</b></td><td><b>Date / Time</b></td><td><b>Size</b></td><td><b>Relevance</b></td><td><b>Directory</b></td></tr>

<%
do while not rs.EOF

response.write "<tr><td>" & rs("doctitle") & "</td><td>" & "<a href=" & "'" & rs("path") & "'" & ">" & rs("filename") & "</a>" & "</td><td>" & rs("write") & "</td><td>" & rs("size") & "</td><td>" & rs("rank") & "</td><td>" & rs("directory") & "</td></tr>"

rs.movenext
loop

response.write "</table>"
set rs=nothing
set q=nothing
set util=nothing
%>

</body>
</html>

"Alan M" <me@work.com¦b¶l¥ó news:em**************@TK2MSFTNGP06.phx.gbl ¤¤¼¶¼g...
need to see code
"ash" <as*@gmail.comwrote in message news:%2****************@TK2MSFTNGP03.phx.gbl...
i'm using the indexing service and CreateRecordSet("nonsequential") in asp.......and i cant retrieve the record although the keywords is matched. Does anybody know how to solve it?

thx
Sep 29 '06 #3
Your search string needs to have the correct syntax.

searchstring = "$CONTENTS "& searchstring

see below

"ash" <as*@gmail.comwrote in message news:uA*************@TK2MSFTNGP06.phx.gbl...
<html>
<%
' This section sets the various configuration variables

formscope="/"
pagesize = 5000
maxrecords=5000
searchstring=request.form("searchstring")
catalogtosearch="web"
searchrankorder="rank[d]"
origsearch=searchstring

searchstring = "$CONTENTS "& searchstring

%>

<%
'This section performs the query

dim q
dim util
set q=server.createobject("ixsso.query")
set util=server.createobject("ixsso.util")
q.query=searchstring
q.catalog=catalogtosearch
q.sortby=searchrankorder
q.columns="doctitle, filename, size, write, rank, directory, path"
q.maxrecords=maxrecords
%>

<%
'This section displays the results

set rs=q.createrecordset("nonsequential")
rs.pagesize=pagesize
response.write"<p>Your search for <b>" & origsearch & "</bproduced "

if rs.recordcount=0 then response.write "no results"
if rs.recordcount=1 then response.write "1 result: "
if rs.recordcount>1 then response.write(rs.recordcount) & " results: "

%>

<table border=1><tr><td><b>Title</b></td><td><b>Filename</b></td><td><b>Date / Time</b></td><td><b>Size</b></td><td><b>Relevance</b></td><td><b>Directory</b></td></tr>

<%
do while not rs.EOF

response.write "<tr><td>" & rs("doctitle") & "</td><td>" & "<a href=" & "'" & rs("path") & "'" & ">" & rs("filename") & "</a>" & "</td><td>" & rs("write") & "</td><td>" & rs("size") & "</td><td>" & rs("rank") & "</td><td>" & rs("directory") & "</td></tr>"

rs.movenext
loop

response.write "</table>"
set rs=nothing
set q=nothing
set util=nothing
%>

</body>
</html>

"Alan M" <me@work.com¦b¶l¥ó news:em**************@TK2MSFTNGP06.phx.gbl ¤¤¼¶¼g...
need to see code
"ash" <as*@gmail.comwrote in message news:%2****************@TK2MSFTNGP03.phx.gbl...
i'm using the indexing service and CreateRecordSet("nonsequential") in asp.......and i cant retrieve the record although the keywords is matched. Does anybody know how to solve it?

thx
Sep 29 '06 #4
Also I would change path to vpath, if you want to return the http path and not the file system path
"ash" <as*@gmail.comwrote in message news:uA*************@TK2MSFTNGP06.phx.gbl...
<html>
<%
' This section sets the various configuration variables

formscope="/"
pagesize = 5000
maxrecords=5000
searchstring=request.form("searchstring")
catalogtosearch="web"
searchrankorder="rank[d]"
origsearch=searchstring
%>

<%
'This section performs the query

dim q
dim util
set q=server.createobject("ixsso.query")
set util=server.createobject("ixsso.util")
q.query=searchstring
q.catalog=catalogtosearch
q.sortby=searchrankorder
q.columns="doctitle, filename, size, write, rank, directory, path"
q.maxrecords=maxrecords
%>

<%
'This section displays the results

set rs=q.createrecordset("nonsequential")
rs.pagesize=pagesize
response.write"<p>Your search for <b>" & origsearch & "</bproduced "

if rs.recordcount=0 then response.write "no results"
if rs.recordcount=1 then response.write "1 result: "
if rs.recordcount>1 then response.write(rs.recordcount) & " results: "

%>

<table border=1><tr><td><b>Title</b></td><td><b>Filename</b></td><td><b>Date / Time</b></td><td><b>Size</b></td><td><b>Relevance</b></td><td><b>Directory</b></td></tr>

<%
do while not rs.EOF

response.write "<tr><td>" & rs("doctitle") & "</td><td>" & "<a href=" & "'" & rs("path") & "'" & ">" & rs("filename") & "</a>" & "</td><td>" & rs("write") & "</td><td>" & rs("size") & "</td><td>" & rs("rank") & "</td><td>" & rs("directory") & "</td></tr>"

rs.movenext
loop

response.write "</table>"
set rs=nothing
set q=nothing
set util=nothing
%>

</body>
</html>

"Alan M" <me@work.com¦b¶l¥ó news:em**************@TK2MSFTNGP06.phx.gbl ¤¤¼¶¼g...
need to see code
"ash" <as*@gmail.comwrote in message news:%2****************@TK2MSFTNGP03.phx.gbl...
i'm using the indexing service and CreateRecordSet("nonsequential") in asp.......and i cant retrieve the record although the keywords is matched. Does anybody know how to solve it?

thx
Sep 29 '06 #5
ash
I try it, but still no results is found when i use ASP, but when I search in the "information form" of Indexing service, it could find some results.
Thx
"Alan M" <me@work.com¦b¶l¥ó news:%2****************@TK2MSFTNGP05.phx.gbl ¤¤¼¶¼g...
Also I would change path to vpath, if you want to return the http path and not the file system path
"ash" <as*@gmail.comwrote in message news:uA*************@TK2MSFTNGP06.phx.gbl...
<html>
<%
' This section sets the various configuration variables

formscope="/"
pagesize = 5000
maxrecords=5000
searchstring=request.form("searchstring")
catalogtosearch="web"
searchrankorder="rank[d]"
origsearch=searchstring
%>

<%
'This section performs the query

dim q
dim util
set q=server.createobject("ixsso.query")
set util=server.createobject("ixsso.util")
q.query=searchstring
q.catalog=catalogtosearch
q.sortby=searchrankorder
q.columns="doctitle, filename, size, write, rank, directory, path"
q.maxrecords=maxrecords
%>

<%
'This section displays the results

set rs=q.createrecordset("nonsequential")
rs.pagesize=pagesize
response.write"<p>Your search for <b>" & origsearch & "</bproduced "

if rs.recordcount=0 then response.write "no results"
if rs.recordcount=1 then response.write "1 result: "
if rs.recordcount>1 then response.write(rs.recordcount) & " results: "

%>

<table border=1><tr><td><b>Title</b></td><td><b>Filename</b></td><td><b>Date / Time</b></td><td><b>Size</b></td><td><b>Relevance</b></td><td><b>Directory</b></td></tr>

<%
do while not rs.EOF

response.write "<tr><td>" & rs("doctitle") & "</td><td>" & "<a href=" & "'" & rs("path") & "'" & ">" & rs("filename") & "</a>" & "</td><td>" & rs("write") & "</td><td>" & rs("size") & "</td><td>" & rs("rank") & "</td><td>" & rs("directory") & "</td></tr>"

rs.movenext
loop

response.write "</table>"
set rs=nothing
set q=nothing
set util=nothing
%>

</body>
</html>

"Alan M" <me@work.com¦b¶l¥ó news:em**************@TK2MSFTNGP06.phx.gbl ¤¤¼¶¼g...
need to see code
"ash" <as*@gmail.comwrote in message news:%2****************@TK2MSFTNGP03.phx.gbl...
i'm using the indexing service and CreateRecordSet("nonsequential") in asp.......and i cant retrieve the record although the keywords is matched. Does anybody know how to solve it?

thx
Sep 29 '06 #6
I copied your page and added this line and it worked for me

searchstring = "$CONTENTS "& searchstring
"ash" <as*@gmail.comwrote in message
news:ua**************@TK2MSFTNGP06.phx.gbl...
I try it, but still no results is found when i use ASP, but when I search in
the "information form" of Indexing service, it could find some results.
Thx
"Alan M" <me@work.com¦b¶l¥ó news:%2****************@TK2MSFTNGP05.phx.gbl
¤¤¼¶¼g...
Also I would change path to vpath, if you want to return the http path and
not the file system path
"ash" <as*@gmail.comwrote in message
news:uA*************@TK2MSFTNGP06.phx.gbl...
<html>
<%
' This section sets the various configuration variables

formscope="/"
pagesize = 5000
maxrecords=5000
searchstring=request.form("searchstring")
catalogtosearch="web"
searchrankorder="rank[d]"
origsearch=searchstring

****
searchstring = "$CONTENTS "& searchstring

****

%>

<%
'This section performs the query

dim q
dim util
set q=server.createobject("ixsso.query")
set util=server.createobject("ixsso.util")
q.query=searchstring
q.catalog=catalogtosearch
q.sortby=searchrankorder
q.columns="doctitle, filename, size, write, rank, directory, path"
q.maxrecords=maxrecords
%>

<%
'This section displays the results

set rs=q.createrecordset("nonsequential")
rs.pagesize=pagesize
response.write"<p>Your search for <b>" & origsearch & "</bproduced
"

if rs.recordcount=0 then response.write "no results"
if rs.recordcount=1 then response.write "1 result: "
if rs.recordcount>1 then response.write(rs.recordcount) & " results:
"

%>

<table
border=1><tr><td><b>Title</b></td><td><b>Filename</b></td><td><b>Date /
Time</b></td><td><b>Size</b></td><td><b>Relevance</b></td><td><b>Directory</b></td></tr>

<%
do while not rs.EOF

response.write "<tr><td>" & rs("doctitle") & "</td><td>" & "<a
href=" & "'" & rs("path") & "'" & ">" & rs("filename") & "</a>" &
"</td><td>" & rs("write") & "</td><td>" & rs("size") & "</td><td>" &
rs("rank") & "</td><td>" & rs("directory") & "</td></tr>"

rs.movenext
loop

response.write "</table>"
set rs=nothing
set q=nothing
set util=nothing
%>

</body>
</html>

"Alan M" <me@work.com¦b¶l¥ó news:em**************@TK2MSFTNGP06.phx.gbl
¤¤¼¶¼g...
need to see code
"ash" <as*@gmail.comwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
i'm using the indexing service and CreateRecordSet("nonsequential")
in asp.......and i cant retrieve the record although the keywords is
matched. Does anybody know how to solve it?

thx
Sep 29 '06 #7
ash
I redirect my indexing service to an specific path, is it matter? Because i
try only the default wwwroot, it works(althought not all data are retrieve).

Best Regards, Stephy Ku Innovation Square 2756 6618
"Slim" <me@here.com¦b¶l¥ó news:%2****************@TK2MSFTNGP03.phx.gbl ¤¤
¼¶¼g...
I copied your page and added this line and it worked for me

searchstring = "$CONTENTS "& searchstring
"ash" <as*@gmail.comwrote in message
news:ua**************@TK2MSFTNGP06.phx.gbl...
I try it, but still no results is found when i use ASP, but when I search
in
the "information form" of Indexing service, it could find some results.
Thx
"Alan M" <me@work.com¦b¶l¥ó
news:%2****************@TK2MSFTNGP05.phx.gbl
¤¤¼¶¼g...
Also I would change path to vpath, if you want to return the http path
and
not the file system path
"ash" <as*@gmail.comwrote in message
news:uA*************@TK2MSFTNGP06.phx.gbl...
<html>
<%
' This section sets the various configuration variables

formscope="/"
pagesize = 5000
maxrecords=5000
searchstring=request.form("searchstring")
catalogtosearch="web"
searchrankorder="rank[d]"
origsearch=searchstring

****
searchstring = "$CONTENTS "& searchstring

****

%>

<%
'This section performs the query

dim q
dim util
set q=server.createobject("ixsso.query")
set util=server.createobject("ixsso.util")
q.query=searchstring
q.catalog=catalogtosearch
q.sortby=searchrankorder
q.columns="doctitle, filename, size, write, rank, directory, path"
q.maxrecords=maxrecords
%>

<%
'This section displays the results

set rs=q.createrecordset("nonsequential")
rs.pagesize=pagesize
response.write"<p>Your search for <b>" & origsearch & "</b>
produced
"

if rs.recordcount=0 then response.write "no results"
if rs.recordcount=1 then response.write "1 result: "
if rs.recordcount>1 then response.write(rs.recordcount) & "
results:
"

%>

<table
border=1><tr><td><b>Title</b></td><td><b>Filename</b></td><td><b>Date /
Time</b></td><td><b>Size</b></td><td><b>Relevance</b></td><td><b>Directory</
b></td></tr>
>
<%
do while not rs.EOF

response.write "<tr><td>" & rs("doctitle") & "</td><td>" & "<a
href=" & "'" & rs("path") & "'" & ">" & rs("filename") & "</a>" &
"</td><td>" & rs("write") & "</td><td>" & rs("size") & "</td><td>" &
rs("rank") & "</td><td>" & rs("directory") & "</td></tr>"

rs.movenext
loop

response.write "</table>"
set rs=nothing
set q=nothing
set util=nothing
%>

</body>
</html>

"Alan M" <me@work.com¦b¶l¥ó
news:em**************@TK2MSFTNGP06.phx.gbl
¤¤¼¶¼g...
need to see code
"ash" <as*@gmail.comwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
i'm using the indexing service and
CreateRecordSet("nonsequential")
in asp.......and i cant retrieve the record although the keywords is
matched. Does anybody know how to solve it?

thx


Oct 3 '06 #8

"ash" <as*@gmail.comwrote in message
news:eG**************@TK2MSFTNGP06.phx.gbl...
>I redirect my indexing service to an specific path, is it matter? Because i
try only the default wwwroot, it works(althought not all data are
retrieve).


maybe not all folders have indeing enabled in IIS service manager

>

Best Regards, Stephy Ku Innovation Square 2756 6618
"Slim" <me@here.com¦b¶l¥ó news:%2****************@TK2MSFTNGP03.phx.gbl
¤¤
¼¶¼g...
>I copied your page and added this line and it worked for me

searchstring = "$CONTENTS "& searchstring
"ash" <as*@gmail.comwrote in message
news:ua**************@TK2MSFTNGP06.phx.gbl...
I try it, but still no results is found when i use ASP, but when I search
in
>the "information form" of Indexing service, it could find some results.
Thx
"Alan M" <me@work.com¦b¶l¥ó
news:%2****************@TK2MSFTNGP05.phx.gbl
>¤¤¼¶¼g...
Also I would change path to vpath, if you want to return the http path
and
>not the file system path
"ash" <as*@gmail.comwrote in message
news:uA*************@TK2MSFTNGP06.phx.gbl...
<html>
<%
' This section sets the various configuration variables

formscope="/"
pagesize = 5000
maxrecords=5000
searchstring=request.form("searchstring")
catalogtosearch="web"
searchrankorder="rank[d]"
origsearch=searchstring

****
searchstring = "$CONTENTS "& searchstring

****

%>

<%
'This section performs the query

dim q
dim util
set q=server.createobject("ixsso.query")
set util=server.createobject("ixsso.util")
q.query=searchstring
q.catalog=catalogtosearch
q.sortby=searchrankorder
q.columns="doctitle, filename, size, write, rank, directory,
path"
q.maxrecords=maxrecords
%>

<%
'This section displays the results

set rs=q.createrecordset("nonsequential")
rs.pagesize=pagesize
response.write"<p>Your search for <b>" & origsearch & "</b>
produced
>"

if rs.recordcount=0 then response.write "no results"
if rs.recordcount=1 then response.write "1 result: "
if rs.recordcount>1 then response.write(rs.recordcount) & "
results:
>"

%>

<table
border=1><tr><td><b>Title</b></td><td><b>Filename</b></td><td><b>Date /
Time</b></td><td><b>Size</b></td><td><b>Relevance</b></td><td><b>Directory</
b></td></tr>
>>
<%
do while not rs.EOF

response.write "<tr><td>" & rs("doctitle") & "</td><td>" & "<a
href=" & "'" & rs("path") & "'" & ">" & rs("filename") & "</a>" &
"</td><td>" & rs("write") & "</td><td>" & rs("size") & "</td><td>" &
rs("rank") & "</td><td>" & rs("directory") & "</td></tr>"

rs.movenext
loop

response.write "</table>"
set rs=nothing
set q=nothing
set util=nothing
%>

</body>
</html>

"Alan M" <me@work.com¦b¶l¥ó
news:em**************@TK2MSFTNGP06.phx.gbl
>¤¤¼¶¼g...
need to see code
"ash" <as*@gmail.comwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
i'm using the indexing service and
CreateRecordSet("nonsequential")
>in asp.......and i cant retrieve the record although the keywords is
matched. Does anybody know how to solve it?

thx



Oct 3 '06 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: Jay | last post by:
Hello all. I've recently transferred our web sites from a Windows2000 server to a Windows2003 server. The transfer went almost flawless until I...
0
by: DLacey | last post by:
I have a .NET C# application that uses the indexing service. It adds folders to the catalog to be indexed, removes them, etc. Currently the...
3
by: jliusolar | last post by:
Hi I am trying to figure out why an application get this error when I am trying to open the application's asmx file from localhost. I don't have...
10
by: Lyle Fairfield | last post by:
By default mdb etc files are not searched by Indexing Service. The default can be changed in Windows XP Pro using Group Policy. I can find no...
0
by: Chung Leong | last post by:
Here's a short tutorial on how to the OLE-DB extension to access Windows Indexing Service. Impress your office-mates with a powerful full-text...
3
by: Chung Leong | last post by:
Here's the rest of the tutorial I started earlier: Aside from text within a document, Indexing Service let you search on meta information stored...
4
by: twilliamson | last post by:
Hello, I am new to the Indexing Service and need a little help. My main goal is for my Windows XP Pro SP2 users is to be able to use the...
0
by: =?Utf-8?B?djJ3aW4=?= | last post by:
Does anyone know what might cause this repeated failure message for the Indexing Service?: _______________________________ The indexing service...
2
by: =?Utf-8?B?SmVycnkgQw==?= | last post by:
I have a server 2008 IIS 7.0 with indexing service installed. I have created the catalog and have a test page using these posts:...
0
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
0
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
1
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.