tags:

views:

1216

answers:

1

I am trying to query a sharepoint list using the following CAML query in a webpart. I have tested the query in U2U CAML Query Builder and Stramit CAML Viewer and it works fine, only returning the matching records, but when I use it in my webpart it return all list items. It is driving me crazyyyyy. Here is the code:

  string camlQuery = string.Format(@"<Query><Where><Contains><FieldRef Name='Title' /><Value Type='Text'>2</Value></Contains></Where></Query>");

  SPQuery query = new SPQuery();
  query.Query = camlQuery;
  SPListItemCollection items = Articles.GetItems(query);
  grid.DataSource = items.GetDataTable();
  grid.DataBind();
+2  A: 

Leave out the surrounding Query tag, just use:

<Where><Contains><FieldRef Name='Title' /><Value Type='Text'>2</Value></Contains></Where>

SPQuery adds the Query tag itself.

Colin
you are the man!
Ali_Abadani
I know... :-P. glad to be of help.
Colin