Mar 12, 2010 at 12:58 AM
Edited Mar 12, 2010 at 1:03 AM
From Joe, via email:
I’m really sorry to bother you but I’m a newbie into this area and seek assistance from you. I am currently and successfully using the jQuery Cascading Dropdowns and it has really saved major booty on this end.
This code works perfectly.
relationshipList: "CME Personnel",
childColumn: "QAP Owner",
CAMLQuery: "<Eq><FieldRef Name='CivMil'/><Value Type='Text'>G</Value></Eq>",
However, if I change the CAML line to this: CAMLQuery: "<Neq><FieldRef Name='CivMil'/><Value Type='Text'>G</Value></Neq>", changing only the Eq to Neq, the wheels promptly fall off.
In running different variants on the idea, I isolated the issue to the “Neq”. If I read your documentation carefully, the above statement should be <And>ed on to the end of whatever was upstream, presumably a Where clause.
So the question is: how do I use an Neq statement with the Cascading Dropdowns?
Many many thanks for your time!
The working code gives me the correct set of records. Anyhow, changing the working code from <EQ> … </EQ> to broken code <NEQ> … </NEQ> gives me the
[image of the debug message was in the email]
So all I did was (try) to say, give me everything that isn’t a “G” . I looked around for other CAML examples and in this site (
http://sharepointmagazine.net/technical/development/writing-caml-queries-for-retrieving-list-items-from-a-sharepoint-list ) it indicated that a “Neq” was a valid operator.
I’ve also tried changing the case on Neq (e.g. Neq, NEQ, NEq) with same results.