CAML Query Syntax?

Thanks for the links, I am actually using both of those tools, and maybe I am extracting the correct data from the lists.

However, when I open my page I see nothing on my content editor web part. I guess I don't know how to write the results into the Web Part.

If you are having trouble creating the web part, please try this:
http://msdn.microsoft.com/en-us/library/aa981241.aspx

thanks but that doesn't help. it is for a Content Query Web Part, I'm trying to use a Content Editor Web Part.

When doing things like this, it's better you simulate most of the code in a console application. This way you can be sure that the caml IS returning the correct data and then copy the logic into the web part.

See http://camlquery.codeplex.com/ to use the caml in a Visual Studio project.

Thanks nmarun for all your help.

I created my web part and deployed it to the sharepoint site. however the web part is now giving me an error that says:

Web Part Error: A Web Part or Web Form Control on this Page cannot be displayed or imported. The type could not be found or it is not registered as safe.

When I created the solution in Visual Studio 2008, I chose a partial trust and only uploaded the webpart to the bin, and I regestered as a safe control in the web.config file. Just to make sure I did the same with a hello world web part and that runs fine on my page.

Any ideas as to why I'm getting this error message.

BTW -------here is my code----------

using System;
using System.Runtime.InteropServices;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Serialization;

using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using Microsoft.SharePoint.WebPartPages;

namespace HandBookRedirect
{
    [Guid("88d94c82-c305-4f0b-8a4b-8c88d44de3b8")]

    public class HandBookRedirect : System.Web.UI.WebControls.WebParts.WebPart
    {
        protected Label lblMessage;

        public HandBookRedirect()
        {
        }

        protected override void CreateChildControls()
        {

            base.CreateChildControls();

            SPControlMode currentControlMode = SPContext.Current.FormContext.FormMode;

            if (currentControlMode == SPControlMode.Display)
            {

              lblMessage = new Label();
              lblMessage.ID = "lblMessage";
              this.Controls.Add(lblMessage);

              string caml = "<Where><Eq><FieldRef Name='Author'/><Value Type='Integer'><UserID Type='Integer'/></Value></Eq></Where>";

              SPQuery query = new SPQuery();
              query.Query = caml;

              SPWeb currentWeb = SPContext.Current.Web;
              SPList list = currentWeb.Lists["handbook"];

              SPListItemCollection results = list.GetItems(query);

              lblMessage.Text = results.Count + " results found.";

              /*if (results.Count == 0)
              {
                  Page.Response.Redirect(list.DefaultViewUrl);
              }*/

     }

        }
    }
}

See if that goes away when you add it to the GAC:
http://www.thescarms.com/dotnet/GacUtil.aspx

Thanks, but it didn't work. I still get the same error, could this be caused by the code?

Jovix, please see the links below:
http://www.mikhaildikov.com/2008/03/unable-to-add-selected-web-parts.html
http://msdn.microsoft.com/en-us/library/ms452873.aspx
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_21523474.html

Thanks, I checked the sites and I'v been working with the web part, I stripped the code down and was able to get the web part to show on the page with a label. however as I added the code that looks at my list, I got a new error. This time the page doesn't load and I get an error that says: Un unexpected error has occurred. with a link to remove the webpart.

So I think now the issue is with my code.

using System;
using System.Runtime.InteropServices;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Serialization;

using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using Microsoft.SharePoint.WebPartPages;

namespace HelloWorld
{
    [Guid("1747ae83-9f82-408c-9203-12e3debed7ab")]
    public class HelloWorld : System.Web.UI.WebControls.WebParts.WebPart
    {
        public HelloWorld()
        {
        }

        protected override void CreateChildControls()
        {
            base.CreateChildControls();

            // TODO: add custom rendering code here.
            Label label = new Label();
            label.ID = "label";
            this.Controls.Add(label);

            string caml = "<Where><Eq><FieldRef Name='Author'/><Value Type='Integer'><UserID Type='Integer'/></Value></Eq></Where>";

            SPQuery query = new SPQuery();
            query.Query = caml;

            SPWeb currentWeb = SPContext.Current.Web;
            SPList list = currentWeb.Lists["Acknowledgement"];

            SPListItemCollection results = list.GetItems(query);


            label.Text = results.Count + " results found.";

        }
    }
}