Display: Cloud | List
Most Popular Tags
Results (38 total) All > query (x)
NULL Predicate Is Not Working (NULL Predicate in Enterprise Search SQL Syntax)
Unfortunately if you try using any of the above NULL predicates you are going to receive an internal SharePoint Interop COM error: HRESULT 0x80044110, which doesn't really reveal much information.There is a workaround solution though, instead of using (column IS NOT NULL) expression, use the following syntax instead: (column > '')
Last modified by artykul8 on 5/27/2010 5:23:52 PM
Tags:  2007  3.0  moss  query  search  sharepoint  sql  wss
Content Query Webpart Header Footer issue (How to: Customize XSL for the Content Query Web Part)
Check it out here http://snahta.blogspot.com/2010/03/content-query-webpart-header-footer.html
Last modified by Sandeep Nahta on 3/24/2010 8:34:10 PM
Tags:  content  cqwp  footer  header  query
C# Example - Query All labels (VersionControlServer.QueryLabels Method (Microsoft.TeamFoundation.VersionControl.Client))
I am very disappointed with the documentation of this API, but to avoid more disappoitment, I let another tip here:To query all Labels on a TFS use the folowing line (the rest of code is equals to the first example) VersionControlLabel[] labels = vc.QueryLabels(null, "$/YourTeamProject/", null, true); Also, You should use TfsTeamProjectCollection or TfsConfigurationServer instead of TeamFou
Last modified by Delpino on 3/5/2010 1:56:25 PM
Last modified by AKrasheninnikov on 3/3/2010 11:29:37 AM
Tags:  caml  query  schema  xml
Old requirement list? (Special Considerations When Using Query Notifications)
The same list, but with more requirements, you can find here: Creating a Query for Notification (http://msdn.microsoft.com/en-us/library/ms181122.aspx)
Last modified by Daniel Wojciechowski on 2/19/2010 7:30:56 AM
SPView.Query update does not work as expected (SPView.Query Property (Microsoft.SharePoint))
If your updating DateTime fields then make sure you convert using SPUtility.CreateISO8601DateTimeFromSystemDateTime(dtStartDate) other wise it does not work. Check out the following url for more info.http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/e6dec453-f295-4111-bd5d-720b05b65e43/#ce471579-8536-4087-9b82-ac66b984a013
Last modified by Vijay Gande on 1/16/2010 3:37:28 AM
Tags:  query  spview
Delete Query SQL Syntax in Microsoft Access (DELETE Statement (Microsoft Access SQL) [Access 2007 Developer Reference])
Here's a paper I wrote which provides additional information on the DELETE query, including situations where it doesn't work and a workaround using DISTINCTROW (unique records property).http://www.fmsinc.com/MicrosoftAccess/query/snytax/delete-query.html Hope this helps.
Last modified by Shahrooz Bigonah on 9/18/2010 10:59:51 PM
Tags:  delete  query  sql
Delete Query SQL Syntax and Troubleshooting (Tips and Techniques for Queries in Access 2007)
Here's a supplemental paper describing the DELETE Query in more detail with examples: http://www.fmsinc.com/MicrosoftAccess/query/snytax/delete-query.htmlThere is also a discussion of when the Delete Query fails with this message "Could not delete from the specified tables", what causes it, and workarounds.
Last modified by LukeChung on 12/8/2009 3:48:15 AM
Tags:  delete  query
Understanding CAML Query (Query Element (Query))
Think of it as reverse polish logic, remember the HP calculators where you entered 4, 5, + and the answer was 9.enter variable1, value1, eq, variable2, value2, eq, and, where, now reverse the orderto get <where> <and> <eq> variable1, value1 </eq> <eq> variable2, value2 </eq> </and></where>which is equal to select * from listwher
Last modified by S.B.Rogers on 10/2/2009 2:41:45 PM
Tags:  caml  query
Developer (Types of Queries)
How many types of Queries are there? What are Inline Queries. Without using Inline Queries can we develop Stored Procedures
Last modified by QA2009 on 9/21/2009 12:10:38 PM
Tags:  query
Page view tracker