Can anybody provide / point me to any examples of using SQL to query WDS using the API... I can't find any examples. I want to actually run a query that finds all items that have a blank characterization, and I can't see how to do this without using a SQL like query.
SQL Queries
Hot Topic
- passing arrays to unmanaged functions - best way ?
- How to write 3-Tier Application using c# windows Application with MS SQL Server 2000?.
- C# .net Binary Serialization
- vertical text in MSHTML editor
- Top Answerers for February
- List of Components
- Distribution and .Net Framework
- Problem in DB
- Cannot uninstall WDS v2.6.5 (5378) under XP SP2
- COm Error
Visual C#
- An interesting and challenging application
- Allow Null In Combo Box
- ArrayList filled with non-string objects to array of string
- Nice Threads!
- How do I login to a website and download files in C#?
- Form Count
- Releasing an Excel Object
- file upload user control
- VB.NET web service from C#
- datagrid shows null
SQL Queries
DarrellMe
But if you're using ExecuteQuery() - you can add the following string to the third parameter:
L"Characterization Is Null"
For example, I created a blank text document called "New Text Document" on my desktop. Then ran:
pQueryObj->ExecuteQuery(L"*",L"DocTitle, Url",L"DocTitle",L"Characterization Is Null AND Contains(\"DocTitle\",'text')",&pRecordset)
And that document was the only result, as expected.
Note that this query may run slower than normal queries because of where Characterization is stored in the index.
Hope that helps.
Gavin G. WANG
Windows Desktop Search supports the same SQL syntax used by Microsoft SharePoint Services. To learn more about this syntax go to:
http://msdn.microsoft.com/library/default.asp url=/library/en-us/spssdk/html/_tahoe_search_sql_syntax.asp
< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Thanks.