WCF web.config file for SharePoint Development Environment

This post has moved here: Programmer Computer

SharePoint Custom RSS Feed Aggregator

This post has moved here: Programmer Computer

Dev Environment: Setting up Visual Studio 2008 SP 1 for Silverlight 2 RTW 2.0.31005.0

This post has moved here: Programmer Computer

MOSS CAML Getting Month and Date Overlapping

Ever wanted to find overlapping date ranges?
For example if you have two date ranges and want to see if they overlap with existing date fields in MOSS.

Here's a picture of what I'm talking about:

Picture 1
Where..
MS = Parameter Month Start Date
ME = Parameter Month End Date
SD = MOSS Field Storing Start Date
ED = MOSS Field Storing End Date

The Picture 1 above produces the following logic:
  Picture 2

There are three possible scenarios:

• Overlapping dates on the start
• Overlapping dates in the middle
• Overlapping dates at the end

Here is the code to reproduce this:

The Code:

DateTime startDateToSearchOn; // parameter DateTime endDateToSearchOn; // parameter string startDateFieldName; // existing MOSS Field Internal name string endDateFieldName; // existing MOSS Field Internal name string startDateToSearchOnString = startDateToSearchOn.ToString("s"); string endDateToSearchOnString = endDateToSearchOn.ToString("s") string startDateToSearchOnString = startDateToSearchOn.ToString("s"); string endDateToSearchOnString = endDateToSearchOn.ToString("s"); string queryXml = "<Query>" + fields.ToString() + "<Where>" + "<Or>" + "<Or>" + "<And>" + "<Leq>" + "<FieldRef Name='" + startDateFieldName + "' />" + "<Value Type='DateTime'>" + startDateToSearchOnString + "</Value>" + "</Leq>" + "<Geq>" + "<FieldRef Name='" + endDateFieldName + "' />" + "<Value Type='DateTime'>" + startDateToSearchOnString + "</Value>" + "</Geq>" + "</And>" + "<And>" + "<Geq>" + "<FieldRef Name='" + startDateFieldName + "' />" + "<Value Type='DateTime'>" + startDateToSearchOnString + "</Value>" + "</Geq>" + "<Leq>" + "<FieldRef Name='" + endDateFieldName + "' />" + "<Value Type='DateTime'>" + endDateToSearchOnString + "</Value>" + "</Leq>" + "</And>" + "</Or>" + "<And>" + "<Leq>" + "<FieldRef Name='" + startDateFieldName + "' />" + "<Value Type='DateTime'>" + endDateToSearchOnString + "</Value>" + "</Leq>" + "<Geq>" + "<FieldRef Name='" + endDateFieldName + "' />" + "<Value Type='DateTime'>" + endDateToSearchOnString + "</Value>" + "</Geq>" + "</And>" + "</Or>" + "</Where>" + "</Query>";

Visual Studio Web Test - Finding Out What Went Wrong

This post has moved here: Programmer Computer

WebTesting - Fiddler, Visual Studio 2008, MOSS

This post has moved here: Programmer Computer

MOSS - Getting Full Error Messages

This post has moved here: Programmer Computer

MOSS - Removing Solution Issues (Execadmsvcjobs)

This post has moved here: Programmer Computer

How to instatiate a MultipleLookupField Control in a Web Part

This post has moved here: Programmer Computer

MOSS Dev Deployment Strategies

This post has moved here: Programmer Computer

How to search all columns of all tables in a database for a keyword

This post has moved here: Programmer Computer

How to Create a MOSS 2007 VPC Image: The Whole 9 Yards

This post has moved here: Programmer Computer

SharePoint Workflow Activities in the Toolbox

This post has moved here: SharePoint Workflow Activities in the Toolbox

MOSS Finding Url to a List for Response.Redirect()

This post has moved here: MOSS Finding Url to a List for Response.Redirect()

Getting your Virtual Machine to acces the Internet

This post has moved here: Getting your Virtual Machine to acces the Internet

MOSS Getting ListItems in a Folder

This post has moved here: MOSS Getting ListItems in a Folder

Updates are currently disallowed on GET requests

This post has moved here: Updates are currently disallowed on GET requests

Enumerate through a Dictionary Object

This post has moved here: Enumerate through a Dictionary Object

Reading from an Excel File with C#

This post has moved here: Reading from an Excel File with C#

ASP.Net Getting the Current Page

This post has moved here: ASP.Net Getting the Current Page

MOSS Getting a List's BaseType for the SPSiteDataQuery (Enum)

This post has moved here: MOSS Getting a List’s BaseType for the SPSiteDataQuery (Enum)

Using SPSiteDataQuery

This post has moved here: Using SPSiteDataQuery

Installation Walk Throughs for MOSS

This post has moved here: Installation Walk Throughs for MOSS

MOSS Adding a Custom Web Part to a Page with SharePoint Designer

This post has moved here: MOSS Adding a Custom Web Part to a Page with SharePoint Designer

MOSS Query String Tips

This post has moved here: MOSS Query String Tips

Getting TortoiseSVN running with CodePlex

This post has moved here: Getting TortoiseSVN running with CodePlex

MOSS Create/Move/Copy items into a SubFolder (Document Library, List Item)

This post has moved here: MOSS Create/Move/Copy items into a SubFolder (Document Library, List Item)

Visual Studio Shortcuts

This post has moved here: Visual Studio Shortcuts

SharePoint Designer, Custom Edit Form - Adding Items & Folders

This post has moved here: SharePoint Designer, Custom Edit Form – Adding Items and Folders

SharePoint Designer Creating Custom Forms with Folders Enabled

This post has moved here: SharePoint Designer Creating Custom Forms with Folders Enabled

MOSS/SharePoint ItemUpdated() & ItemUpdating Events Not Picking Up Content Type Metadata

This post has moved here: MOSS ItemUpdated() and ItemUpdating Events Not Picking Up Content Type Metadata

SharePoint Designer & Supporting Files Issue

This post has moved here: SharePoint Designer, Custom Edit Form – Adding Items and Folders

SharePoint Designer/MOSS: ReArranging fields in Edit Form

This post has moved here: SharePoint Designer: ReArranging fields in Edit Form

MOSS, Visual Studio Post-build Event

This post has moved here: MOSS: Visual Studio Post-build Event

My MOSS Development Environment

This post has moved here: My MOSS Development Environment

Can't Step Through Web Service from Client Application

This post has moved here: Can’t Step Through Web Service from Client Application

Getting the Current UserName

This post has moved here: Getting the Current UserName

Dealing with Big Lists - MOSS (SharePoint 2007)

This post has moved here: Dealing with Big Lists – MOSS (SharePoint 2007)