[OzMOSS] RE: CAML Query not filtering - Any suggestions

[Trevor Andrew]

Hi All,

 

I have a CAML query, which I'm building in U2U CAML's builder - when I test
it in CAML Builder, it returns the one custom list item I'm seeking. The
CAML generated is shown below:

 

<Query><Where><Eq><FieldRef Name="Title" /><Value
Type="Text">ABC</Value></Eq></Where></Query>

 

But when the query is executed using the following code, I get all of the
items in the list returned:

 

                SPList configurationList =
thisList.ParentWeb.Lists[configurationListName];

                SPQuery getConfigurationValueQuery = new SPQuery();

                queryCAML =

                    @"<Query><Where><Eq><FieldRef Name=""Title"" /><Value
Type=""Text"">{0}</Value></Eq></Where></Query>";

                getConfigurationValueQuery.Query = string.Format(queryCAML,
configurationValueName);

                SPListItemCollection configurationValues =
configurationList.GetItems(getConfigurationValueQuery);

 

I've verified that the string format substitutes the correct value into the
CAML query ...

 

Any suggestions kindly welcomed ...

 

Cheers,

Trevor Andrew

 




------------------------------------------------------------------- OzMOSS.com 
- to unsubscribe from this list, send a message back to the list with 
'unsubscribe' as the subject.
Powered by mailenable.com