Discussion:
iterate/loop indexing services files
(too old to reply)
AC
2006-10-26 02:33:57 UTC
Permalink
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
Hilary Cotter
2006-10-26 12:46:21 UTC
Permalink
this is a terrible way of doing it but

select * from openquery(webLS,'select path,filename from webCat..scope()
where size >0')

where my catalog name is webCat, and my linked server name is also webLS
--
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
Post by AC
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
Hilary Cotter
2006-10-26 12:47:04 UTC
Permalink
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
Post by AC
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
AC
2006-10-26 14:18:01 UTC
Permalink
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
Post by Hilary Cotter
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
Post by AC
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
Hilary Cotter
2006-10-26 15:29:37 UTC
Permalink
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
Post by AC
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
Post by Hilary Cotter
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
Post by AC
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
AC
2006-10-27 05:28:44 UTC
Permalink
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
Post by Hilary Cotter
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
Post by AC
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
Post by Hilary Cotter
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
Post by AC
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
Loading...