Re: iterate/loop indexing services files
- From: "AC" <no@xxxxxxx>
- Date: Fri, 27 Oct 2006 01:28:44 -0400
Thank you very much for this detailed answer. I was at a client site and
wouldn't get back until late. I was hoping to get a short answer about
syntax such as -- ixsso.Query="Select path, Filename from Web". I'm sorry
I was not more explicit with my request. It's a good example for a newbie.
:)
Is the Indexing Services book coming out? I think I would like it.
Thank you again Hilary.
--AC
"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:eNCCLNR%23GHA.4464@xxxxxxxxxxxxxxxxxxxxxxx
That is for SQL server or MSIDXS, for ixsso it is
set ixsso=createobject("Ixsso.query")
ixsso.Catalog="web"
ixsso.Columns="Path,FileName"
ixsso.Query="Select path, Filename from Web"
set RecordSet=Ixsso.CreateRecordSet("nonSequential")
do while not RecordSet.EOF
recordset.moveNext
wscript.echo RecordSet("path")
loop
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"AC" <no@xxxxxxx> wrote in message
news:OYVnRmQ%23GHA.4708@xxxxxxxxxxxxxxxxxxxxxxx
Thank you for your replies. I will try them tonight. I just need to run
this once so performance isn't a big deal.
Do the queries require SQL Server? I am using the ixsso objects.
I looked all over for this answer.
--AC
"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:uelDWyP%23GHA.360@xxxxxxxxxxxxxxxxxxxxxxx
try this
select path,filename from webCat..scope() where size >0'
where my catalog name is webCat
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"AC" <no@xxxxxxx> wrote in message
news:el$h5cK%23GHA.5092@xxxxxxxxxxxxxxxxxxxxxxx
How can I loop through or get a resultset with all files in an indexing
services catalog?
Is there a way to make the returning recordset contain all records?
I want to go through and grab the FileIndex from all files. The files
are static so I don't have to worry about the value changing.
Thanks in advance
Follow-ups to microsoft.public.inetserver.indexserver
.
- References:
- Re: iterate/loop indexing services files
- From: Hilary Cotter
- Re: iterate/loop indexing services files
- From: AC
- Re: iterate/loop indexing services files
- From: Hilary Cotter
- Re: iterate/loop indexing services files
- Prev by Date: Re: display hit results in proper format
- Next by Date: Index Services query results less than reported in Indexing Services
- Previous by thread: Re: iterate/loop indexing services files
- Next by thread: Index Services query results less than reported in Indexing Services
- Index(es):
Relevant Pages
|
Loading
