Check out my new blog on SharePoint 2007 on the SharePoint 2007 platform:

http://www.thesug.org/blogs/MOSSMania/default.aspx

For my subscribers, update your readers, here is my new RSS Feed Url:
http://www.thesug.org/blogs/MOSSMania/_layouts/listfeed.aspx?List={3f7d7b8a-a822-409c-97ed-d4367160f6d7}

Too many certifications is never a bad thing.  I was playing around with Microsoft's logo builder after Pearson VUE finally got my microsoft profile updated, a month after I passed the tests and I noticed that if I tried to create a logo with all 4 of my WSS/MOSS certifications, I received an error telling me to remove one.  I worked hard for all four, so I would want them all displayed.

 Microsoft's site says that "Due to design and branding requirements, a logo may only display up to four or six lines."  If they moved Configuration up, that would allow for two more lines.  Also, why is MOSS 2007 Application Development on one line and WSS 3.0 Application Development is on two lines? 

On the usage guide page, it does not say that the certifcation list is limited to 4 to 6 lines, but to 4 to 6 certifcation areas:
The right side of the bar can accommodate 4-6 certification areas depending upon the credential.  I also have other problems with this since when I will go to upgrade my MCAD/MCSD, I will be getting more MCTS certs, which won't be able to be all listed together.  I still think these certifications should have been MSCS (Microsoft Sharepoint Certified Specialist) since MCSS is already taken by Microsoft Certified Security Specialist instead of MCTS.

Out of the box, the content query web part can only get items from one content type, but what happens if you want it to display items from more than one content type?  You don't have to write a custom web part to do this thanks to Microsoft adding overrides in their content query web part. 

First, build the CQWP (Content Query Web Part) with everything how you want it, including the query, then you will need to export it to a location on your drive.  To export the web part, navigate to the page that contains the web part.  Open up the page in edit mode and on that page, click on the edit drop down menu for the web part and click "Export."

Save the file locally.  Once you have exported the web part as a .webpart file, open it with notepad and edit the ListsOverride property.

If you want to get everything based on a Generic List (BaseType = 0), you would use the following property:

 <property name="ListsOverride" type="string"><![CDATA[ <Lists BaseType="0"> </Lists>]]></property>

 
If you want to get everything based on a document library (BaseType = 1), you would use the following property:

 <property name="ListsOverride" type="string"><![CDATA[ <Lists BaseType="1"> </Lists>]]></property>

 Once you have finished editting the webpart, save the file.  Now we have to import the new .webpart file.  To do this, go to "Site Actions" -> "Site Settings" -> "Modify All Site Settings" on the top level site.

 Under "Galleries", click on "Web Parts".  Now click the "Upload" button.

Click on the "Browse" button and select the .webpart file that you made changes to.

Now set all of the properties for the webpart and click "OK" when finished.

Now browse to the page you want to add the web part to.  Open up the page in edit mode and in the web part zone where you want to add the web part, click on "Add a web part" and select your new webpart and then click "Add."

How to: Customize the Content Query Web Part by using Custom Properties
http://msdn2.microsoft.com/en-us/library/aa981241.aspx

"<Lists BaseType='1' MaxListsLimit='0'/>"

"<Lists BaseType='1' MaxListLimit='0'/>"

This made the error go away as it let me search all of the lists in the entire site.  Not specifying a MaxListLimit would only search 1000 lists, but seems to throw an error if there are more than 1000 lists, instead of just searching the first 1000 that it finds.  I would recommend always using '0' if you are not sure that the client will have less than 1000 lists. 

Getting Posting Values

In MCMS 2002:

In SharePoint Server 2007:

Setting Postings Values

In MCMS 2002:

Posting p=null;
String text1 = "new attachment text";
String text2 = "new html";
String text3 = "new image href";
//Code to get to the posting
AttachmentPlaceholder att = p.Placeholders["attachment1"] as 
   AttachmentPlaceholder;
att.AttachmentText = text1;
HtmlPlaceholder html = p.Placeholders["html1"] as HtmlPlaceholder;
html.Html = text2;
ImagePlaceholder img = p.Placeholders["image1"] as ImagePlaceholder;

img.Href = text3;
CmsHttpContext.Current.CommitAll();

In SharePoint Server 2007:

I was having trouble building a solution in VIsual Studio 2005 and I was getting the following error.

"sgen.exe" exited with code 1  

 I found that following the steps below fixed it:

Open up the project properties.
Open up the build tab.
Set "Generate Serialization Assembly" to "Off"

item["HyperLinkColumn"] = "http://www.google.com, Google";

Colligo Reader allows a user to access offline content for all versions of SharePoint which includes SharePoint Services (WSS 3.0 & 2.0) as well as MOSS 2007 and SharePoint Portal Server SPS 2003.  The install is rather small and requires no server modifications since it uses standard web services and site permissions to access content.

Download it here:

http://www.colligo.com/products/sharepoint/reader_home.asp

Mirjam's blog lists some uses of SPContext.  Here are a few I grabbed from his post:

SPList currentList = SPContext.Current.List;
SPWeb currentSite = SPContext.Current.Web;
SPSite currentSiteCollection = SPContext.Current.Site;
SPWebApplication currentWebApplication = SPContext.Current.Site.WebApplication;
SPListItem item = (SPListItem)SPContext.Current.Item;
SPUser user = SPContext.Current.Web.CurrentUser;

He also explains the difference between the SPSiteDataQuery object and the SPQuery object.

Check it out here: http://www.sharepointblogs.com/mirjam/archive/2007/02/23/19983.aspx

	// create list
	web.Lists.Add(listName, "", SPListTemplateType.GenericList);
	list = web.Lists[listName];

	// Add your fields to the list
	list.Fields.Add("Field1", SPFieldType.Text, false);
	list.Fields.Add("Field2", SPFieldType.Text, false);

	// You can change the title of a field by accessing the SPField object
	SPField field1 = list.Fields["Field1"];
	field1.Title = "Title Of Field 1";
	field1.Update();

	// You have to use a specialized string collection to add fields to a view
	System.Collections.Specialized.StringCollection strCol = new System.Collections.Specialized.StringCollection();
	strCol = new System.Collections.Specialized.StringCollection();
	strCol.Add("Field1");
	strCol.Add("Field2");

	// You can use a standard query here to only return certain data
	string query = string.Empty;	
	query = "";
	SPView view = null;
	view = list.Views.Add("Items Sorted By Field1", strCol, query, 20, true, false);

	list.Update();

Here is a link that helped me in creating my first MOSS WebPart, since it is a little different than SharePoint 2003.  I hope this helps you as much as it helped me:

http://www.codeguru.com/csharp/.net/net_asp/webforms/article.php/c12293__1/

I had to create a custom event handler in MOSS to calculate the remaining budget for a user, here is the code:  

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SharePoint;

namespace MP.EventHandlers
{
    public class EventHandler1 : SPItemEventReceiver
    {
        public override void ItemAdded(SPItemEventProperties properties)
        {
            base.ItemAdded(properties);
            SPListItem listItem = properties.ListItem;
            // Update List Item Properties Here
            listItem.Update();
        }

        public override void ItemUpdated(SPItemEventProperties properties)
        {
            base.ItemUpdated(properties);
            SPListItem listItem = properties.ListItem;
            // Update List Item Properties Here
            listItem.Update();
        }        
    }    
}