whats wrong with my query CAML

Question

$caml = '<Where><AND><Neq><FieldRef Name="marking" />
<Value Type="Text">Off-S</Value></Neq><Neq><FieldRef Name="marking" />
<Value Type="Text">Off</Value></Neq></AND></Where>'

I have this query, which doesn't return anything. What I want is it to return all the items that are in the column marking that are not equal to Off-S and Off

Answer 1

Your <And> tag is in all caps; CAML is case sensitive. Try this:

<Where>
    <And>
        <Neq>
            <FieldRef Name="marking" />
            <Value Type="Text">Off-S</Value>
        </Neq>
        <Neq>
            <FieldRef Name="marking" />
            <Value Type="Text">Off</Value>
        </Neq>
    </And>
</Where>

And like MdMazzotti said, use a tool to build your CAML queries.

Answer 2

CAML keywords are case-sensitive, try writing "And" instead of "AND".

Answer 3

I use a caml query tool called U2U Caml query. Its free and easy. http://www.u2u.be/Software

Answer 4

Have you tried :

$caml = '<Where><AND><Or><Neq><FieldRef Name="marking" />
<Value Type="Text">Off-></Value></Neq><Or><Neq><FieldRef Name="marking" />
<Value Type="Text">Off</Value></Neq></Or></Or></AND></Where>'

maybe this helps you