I'm using SPServices to query a list, using CAML, and the column I'm searching (Title) have values that contains < and >.
Is there anyway I can use CAML to find these values? It seems that I'm getting undefined returned. If the string doesn't contain these characters, I get exactly what I want back.
Using U2U CAML Query Builder, it returns this CAML:
<Query><Where><Eq><FieldRef Name="Title" /><Value Type="Text">Value < 10</Value></Eq></Where></Query>
where the value of title is actually Value < 10.
Thank you very much,
Here is my solution that worked for me.
var a = "Test & < > '10'"; var newA = a.replace(/&/g, "&").replace(/</g,"<").replace(/>/g, ">").replace(/'/g,"'").replace(/"/g, """);
Then I pass in newA to my SPServices call where I'm using CAML to find my data.
CAMLQuery: "<Query><Where><And><Eq><FieldRef Name='title'/><Value Type='Text'>" + newA + "</Value></Eq>" ....