|
Home > Archive > IIS Index Server > March 2005 > Index Server Provider and MSIDXS searching Meta Tags
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 |
Index Server Provider and MSIDXS searching Meta Tags
|
|
| Pierre Boisvenue 2005-03-02, 6:04 pm |
| I have cached a Property meta tag named dc.description in Index server to
VT_LPWSTR 4 and would like a sample of how to search on that.
The web is full of syntax documentation with no real example like
http://www.hostingsolutions.net/ixqlang.htm#Examples
My current query is:
SELECT Filename, DocTitle, VPath, Characterization FROM WEBINFO WHERE
CONTAINS('" & Me.SearchTerms & "') "
What is the SQL syntax for searching on @dc.description ?
I have tried
SELECT Filename, DocTitle, VPath, Characterization FROM WEBINFO WHERE
@dc.description = "MyDescritpion"
and get no HITS.
| |
| Hilary Cotter 2005-03-04, 2:48 am |
| use defaultcolumnfile to assign a friendly name to your property. Then
query it like this
select dc_description, path from scope() where
dc_description=''"MyDescritpion"'''
note that you will have to give your property a friendly name replacing the
.. with a _
--
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
"Pierre Boisvenue" <pierre7@videotron.ca> wrote in message
news:%23yO7UPzHFHA.2700@TK2MSFTNGP09.phx.gbl...
> I have cached a Property meta tag named dc.description in Index server to
> VT_LPWSTR 4 and would like a sample of how to search on that.
> The web is full of syntax documentation with no real example like
>
> http://www.hostingsolutions.net/ixqlang.htm#Examples
>
> My current query is:
>
> SELECT Filename, DocTitle, VPath, Characterization FROM WEBINFO WHERE
> CONTAINS('" & Me.SearchTerms & "') "
>
> What is the SQL syntax for searching on @dc.description ?
>
> I have tried
>
> SELECT Filename, DocTitle, VPath, Characterization FROM WEBINFO WHERE
> @dc.description = "MyDescritpion"
>
> and get no HITS.
>
>
| |
| Hilary Cotter 2005-03-04, 2:48 am |
| another reason you might not be getting hits is because you have spelled
MyDescription incorrectly.
--
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
"Pierre Boisvenue" <pierre7@videotron.ca> wrote in message
news:%23yO7UPzHFHA.2700@TK2MSFTNGP09.phx.gbl...
> I have cached a Property meta tag named dc.description in Index server to
> VT_LPWSTR 4 and would like a sample of how to search on that.
> The web is full of syntax documentation with no real example like
>
> http://www.hostingsolutions.net/ixqlang.htm#Examples
>
> My current query is:
>
> SELECT Filename, DocTitle, VPath, Characterization FROM WEBINFO WHERE
> CONTAINS('" & Me.SearchTerms & "') "
>
> What is the SQL syntax for searching on @dc.description ?
>
> I have tried
>
> SELECT Filename, DocTitle, VPath, Characterization FROM WEBINFO WHERE
> @dc.description = "MyDescritpion"
>
> and get no HITS.
>
>
|
|
|
|
|