I had the same sort of issue, for some reason it does not like XML in @"" style.
I changed from
@"<Query><Where><Eq><FieldRef Name='Title' /><Value
Type='Text'>{0}</Value></Eq></Where></Query>";
to
"<Query><Where><Eq><FieldRef Name=\"Title\" /><Value
Type=\"Text\">{0}</Value></Eq></Where></Query>";
________________________________
From: [EMAIL PROTECTED] on behalf of Paul Noone
Sent: Fri 6/6/2008 3:30 PM
To: listserver@ozMOSS.com
Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions
It's possible your ASP escapes are being taken literally in the query.
You might also variations of:
@"<Query><Where><Eq><FieldRef Name='Title' /><Value
Type='Text'>{0}</Value></Eq></Where></Query>";
and
@'<Query><Where><Eq><FieldRef Name="Title" /><Value
Type="Text">{0}</Value></Eq></Where></Query>';
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Cosier
Sent: Friday, 6 June 2008 12:27 PM
To: listserver@ozMOSS.com
Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions
Not sure, but maybe remove the <Query> element, probably not needed. Also feel
free to use single quotes instead of doubles to make the code cleaner.
Matthew Cosier
Readify | Dev Centre Lead
M: +61 401 932 250 | E: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Blog:
http://cosier.wordpress.com <http://cosier.wordpress.com/>
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor Andrew
Sent: Friday, 6 June 2008 12:22 PM
To: listserver@ozMOSS.com
Subject: [OzMOSS] RE: CAML Query not filtering - Any suggestions
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
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
------------------------------------------------------------------- OzMOSS.com
- to unsubscribe from this list, send a message back to the list with
'unsubscribe' as the subject.
Powered by mailenable.com
________________________________
____________________________________________________________________________
This e-mail is intended for the use of the addressed recipient(s) only and may
contain confidential and privileged information. If you have received this
message in error, please delete the message and any attachments and copies
immediately; and notify the sender by return e-mail.
Any views expressed in this message or any attachments are those of the
individual sender and do not necessarily represent the corporate opinion of the
Catholic Education Office (CEO), Sydney.
The CEO Privacy Policy is located at http://www.ceo.syd.catholic.edu.au
____________________________________________________________________________
------------------------------------------------------------------- OzMOSS.com
- to unsubscribe from this list, send a message back to the list with
'unsubscribe' as the subject.
Powered by mailenable.com
------------------------------------------------------------------- OzMOSS.com
- to unsubscribe from this list, send a message back to the list with
'unsubscribe' as the subject.
Powered by mailenable.com
<<winmail.dat>>
