Click here to get back home

Developer Question w/ WDS SDK

 HomeNewsGroups | Search | About
 microsoft.public.msn.search    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Developer Question w/ WDS SDK Michael H 08-18-2005
Posted by Michael H on August 18, 2005, 4:14 pm
Please log in for more thread options



Is this even the right place? Well,


1. does anyone know if there's available documentation on which
columns are available to query for? I found some from a MSN space blog
by Steve Ickman
http://spaces.msn.com/members/WDSTech/Blog/cns!1p0tYOH23YIjQaVyUIcoDDIA!146.entry

but also see "We don't have them documented yet" on the same page :(


I can do a simple sql query through the SDK's

ExecuteSQLQuery( System.String lpcwstrSQL)

but it took luck to find the correct "FROM" information and "WHERE"
information. The Column names didn't match up directly with the WDS
GUI so I had a bit a trouble at first finding a column name that
didn't throw an error during debug.

SELECT filename
FROM "MyIndex"..scope()
WHERE CONTAINS(*,'"imate*"',1033)
ORDER BY filename


2. I've noticed that if the WDS service gets stop for whatever reason,
I didn't even realize it was closed, I can't query against it. Does
the SDK provide a way to programmatically turn on the WDS service? Can
we, through the SDK, for an index/re-index or even specify which
specific directories/file types to index ? I didn't see anything
looking through the SDK.

Thanks,


Michael Hughes - Redmond, WA/Silverton, OR
http://www.MrHankyTrivia.net - http://www.MrHankyTrivia.com
http://aa7ml.net - http://aa7ml.com


Posted by Michael S. Sche on November 2, 2005, 2:55 pm
Please log in for more thread options
Did you ever find the complete list of columns?
--
Michael S. Scherotter
Business Solutions Architect
Mindjet Corporation


"Michael H" wrote:

>
> Is this even the right place? Well,
>
>
> 1. does anyone know if there's available documentation on which
> columns are available to query for? I found some from a MSN space blog
> by Steve Ickman
>
http://spaces.msn.com/members/WDSTech/Blog/cns!1p0tYOH23YIjQaVyUIcoDDIA!146.entry
>
> but also see "We don't have them documented yet" on the same page :(
>
>
> I can do a simple sql query through the SDK's
>
> ExecuteSQLQuery( System.String lpcwstrSQL)
>
> but it took luck to find the correct "FROM" information and "WHERE"
> information. The Column names didn't match up directly with the WDS
> GUI so I had a bit a trouble at first finding a column name that
> didn't throw an error during debug.
>
> SELECT filename
> FROM "MyIndex"..scope()
> WHERE CONTAINS(*,'"imate*"',1033)
> ORDER BY filename
>
>
> 2. I've noticed that if the WDS service gets stop for whatever reason,
> I didn't even realize it was closed, I can't query against it. Does
> the SDK provide a way to programmatically turn on the WDS service? Can
> we, through the SDK, for an index/re-index or even specify which
> specific directories/file types to index ? I didn't see anything
> looking through the SDK.
>
> Thanks,
>
>
> Michael Hughes - Redmond, WA/Silverton, OR
> http://www.MrHankyTrivia.net - http://www.MrHankyTrivia.com
> http://aa7ml.net - http://aa7ml.com
>

Posted by Hilary Cotter on November 3, 2005, 12:03 pm
Please log in for more thread options
have a look in C:\Documents and Settings\hcotter\Local Settings\Application
Data\Microsoft\Desktop Search\Config

I think its the mscolumns doc.

--
Hilary Cotter
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
> Did you ever find the complete list of columns?
> --
> Michael S. Scherotter
> Business Solutions Architect
> Mindjet Corporation
>
>
> "Michael H" wrote:
>
> >
> > Is this even the right place? Well,
> >
> >
> > 1. does anyone know if there's available documentation on which
> > columns are available to query for? I found some from a MSN space blog
> > by Steve Ickman
> >
http://spaces.msn.com/members/WDSTech/Blog/cns!1p0tYOH23YIjQaVyUIcoDDIA!146.entry
> >
> > but also see "We don't have them documented yet" on the same page :(
> >
> >
> > I can do a simple sql query through the SDK's
> >
> > ExecuteSQLQuery( System.String lpcwstrSQL)
> >
> > but it took luck to find the correct "FROM" information and "WHERE"
> > information. The Column names didn't match up directly with the WDS
> > GUI so I had a bit a trouble at first finding a column name that
> > didn't throw an error during debug.
> >
> > SELECT filename
> > FROM "MyIndex"..scope()
> > WHERE CONTAINS(*,'"imate*"',1033)
> > ORDER BY filename
> >
> >
> > 2. I've noticed that if the WDS service gets stop for whatever reason,
> > I didn't even realize it was closed, I can't query against it. Does
> > the SDK provide a way to programmatically turn on the WDS service? Can
> > we, through the SDK, for an index/re-index or even specify which
> > specific directories/file types to index ? I didn't see anything
> > looking through the SDK.
> >
> > Thanks,
> >
> >
> > Michael Hughes - Redmond, WA/Silverton, OR
> > http://www.MrHankyTrivia.net - http://www.MrHankyTrivia.com
> > http://aa7ml.net - http://aa7ml.com
> >



Posted by Hilary Cotter on November 3, 2005, 12:05 pm
Please log in for more thread options
actually its more likely rsschema.txt

--
Hilary Cotter
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
> Did you ever find the complete list of columns?
> --
> Michael S. Scherotter
> Business Solutions Architect
> Mindjet Corporation
>
>
> "Michael H" wrote:
>
> >
> > Is this even the right place? Well,
> >
> >
> > 1. does anyone know if there's available documentation on which
> > columns are available to query for? I found some from a MSN space blog
> > by Steve Ickman
> >
http://spaces.msn.com/members/WDSTech/Blog/cns!1p0tYOH23YIjQaVyUIcoDDIA!146.entry
> >
> > but also see "We don't have them documented yet" on the same page :(
> >
> >
> > I can do a simple sql query through the SDK's
> >
> > ExecuteSQLQuery( System.String lpcwstrSQL)
> >
> > but it took luck to find the correct "FROM" information and "WHERE"
> > information. The Column names didn't match up directly with the WDS
> > GUI so I had a bit a trouble at first finding a column name that
> > didn't throw an error during debug.
> >
> > SELECT filename
> > FROM "MyIndex"..scope()
> > WHERE CONTAINS(*,'"imate*"',1033)
> > ORDER BY filename
> >
> >
> > 2. I've noticed that if the WDS service gets stop for whatever reason,
> > I didn't even realize it was closed, I can't query against it. Does
> > the SDK provide a way to programmatically turn on the WDS service? Can
> > we, through the SDK, for an index/re-index or even specify which
> > specific directories/file types to index ? I didn't see anything
> > looking through the SDK.
> >
> > Thanks,
> >
> >
> > Michael Hughes - Redmond, WA/Silverton, OR
> > http://www.MrHankyTrivia.net - http://www.MrHankyTrivia.com
> > http://aa7ml.net - http://aa7ml.com
> >



Similar ThreadsPosted
question??? August 27, 2005, 7:28 am
API Query question August 18, 2005, 5:26 pm
Query Result Question August 19, 2005, 10:21 am
WDS Search Query question January 4, 2006, 3:39 pm
PDF and general usage question April 1, 2006, 5:06 pm
Password Question for ID-File April 13, 2006, 10:01 am
msn search and pay per click question. August 21, 2006, 5:43 am
Question about Windows search APIs and pay per click... August 27, 2006, 6:58 am
Search Dev Question: mapi urls returned are not so good... May 2, 2006, 3:01 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap