I wrote a short console application to upload documents as attachments to a list and I ran into two problems that probably cost me 30 minutes today. I’m writing this to remind myself and to save you 30 minutes.
- Problem: When I run SPList.GetItems(), it returns the entire list, rather than the items I queried for.
- Answer: Are you using the U2U CAML creator to define the CAML syntax for your query (you should be). Be sure that you remove the <Query> tags. If the query returns all of the items, that means your CAML syntax was malformed. The query parameter should start with a <Where> tag.
- Problem: When I run SPList.GetItems(), I get the error message that
One or more field types are not installed properly.
- Answer: Are you using the Internal field name? The most common cause of this is not having an _x0020 instead of a space in your field name (eg First_x0020Name instead of First Name)