|
Home > Archive > IIS Index Server > October 2006 > iterate/loop indexing services files
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
iterate/loop indexing services files
|
|
|
| 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-28, 1:40 pm |
| 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
"AC" <no@spam.me> wrote in message
news:el$h5cK%23GHA.5092@TK2MSFTNGP04.phx.gbl...
> 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-28, 1:40 pm |
| 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@spam.me> wrote in message
news:el$h5cK%23GHA.5092@TK2MSFTNGP04.phx.gbl...
> 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
>
| |
|
| 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@gmail.com> wrote in message
news:uelDWyP%23GHA.360@TK2MSFTNGP04.phx.gbl...[vbcol=seagreen]
> 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@spam.me> wrote in message
> news:el$h5cK%23GHA.5092@TK2MSFTNGP04.phx.gbl...
| |
| Hilary Cotter 2006-10-28, 1:40 pm |
| 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@spam.me> wrote in message
news:OYVnRmQ%23GHA.4708@TK2MSFTNGP05.phx.gbl...
> 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@gmail.com> wrote in message
> news:uelDWyP%23GHA.360@TK2MSFTNGP04.phx.gbl...
>
>
>
| |
|
| 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@gmail.com> wrote in message
news:eNCCLNR%23GHA.4464@TK2MSFTNGP02.phx.gbl...[vbcol=seagreen]
> 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@spam.me> wrote in message
> news:OYVnRmQ%23GHA.4708@TK2MSFTNGP05.phx.gbl...
|
|
|
|
|