SharePoint User Group UK

When i try to execute a caml query with a caml like:

"<Where><Neq><FieldRef Name="MyNoteField" /><Value Type="Note">any string here</Value></Neq></Where>"

I get the following exception:
System.Data.SqlClient.SqlException: The data types ntext and nvarchar are incomp
atible in the not equal to operator.

I tried to use diferent operators and like 'Eq' and 'BeginWith' and had no problems.

Is this a known issue? or is a problem in my sharepoint installation?

I am running wss v3 with service pack 1


Thanks,
Santiago Ferreira

Try this tool to create (or test your) query:

http://www.u2u.info/Blogs/Patrick/Lists/Posts/Post.aspx?ID=1252

Thanks,

Alex

Thanks Alex for the answer.
    I tried the U2U caml query tool, i always use it (it's a great tool!) but the same error happends. It throws the exception.

Santiago, Where are you getting the Value type="Note" from? try changing this to "Text" and re-running the query.

What field type is MyNoteField?

Paul.

---

www.myfatblog.co.uk
MCTS: WSS 3.0
MCTS: MOSS 2007

Hi Paul, thanks for the answer,

    MyNoteField is a multi line field type (internal type is Note). I also tried to change in the caml query the line "<Value Type="Note">" with "<Value Type="Text">" and "<Value>". The problem is not this part of the query, if i change the caml operator to 'Eq' or to 'BeginWith' i have no problem at all. Also if i change the target field to a field with other type (like "Text") it works fine.

    Can you reproduce the error? if not, i guess is my installation otherwise is a sharepoint bug

Thanks a lot for the help
Santiago Ferreira

I think I agree with you, it looks like you can't use the Neq operator against multiline types. I've used it many times on simple text fields without any problem.

I've just created a new column and it doesn't work with U2U's caml builder.. I'm guessing it just doesn't like a text comparison with the multiline string, not sure how this is stored in the object model, possible a string array in which case I can udnerstand the comparison not working. I just tried and you can't use Equal either.. You can use begins with though!

Paul.

---

www.myfatblog.co.uk
MCTS: WSS 3.0
MCTS: MOSS 2007

Thanks!

Now that i know is not my sharepoint installation i'll look for more information on the web about which operators can be applied to every field type. Do you know if such a list even exists?

I believe the WSS SDK has some detail on this but I've not examined it. Probably a good place to start tho.

---

www.myfatblog.co.uk
MCTS: WSS 3.0
MCTS: MOSS 2007