AmosFiveSix.com

This information is based on the United States Postal Service standard abbreviations for states and territories: http://www.usps.com/ncsc/lookups/usps_abbreviations.html

If your data needs to include addresses for the continental United States only, it's best to check if the address's state is included in the list of continental states, rather than checking if the state is not in the list of non-continental states.

For example, this incorrect SQL snipit allows addresses in Guam and other territories to pass through:

WHERE store.State NOT IN ('AK','HI','VI','PR')

This is the correct code to check for continental United States:

WHERE store.State IN ('AL', 'AZ', 'AR', 'CA', 'CO', 'CT', 'DE', 'DC', 'FL', 'GA', 'ID', 'IL', 'IN', 'IA', 'KS', 'KY', 'LA', 'ME', 'MD', 'MA', 'MI', 'MN', 'MS', 'MO', 'MT', 'NE', 'NV', 'NH', 'NJ', 'NM', 'NY', 'NC', 'ND', 'OH', 'OK', 'OR', 'PA', 'RI', 'SC', 'SD', 'TN', 'TX', 'UT', 'VT', 'VA', 'WA', 'WV', 'WI', 'WY') AND store.Country = 'United States'

I just found these great indexes for the W3C HTML and CSS documentation. It uses a frameset with a list of all HTML elements or CSS properties in a frame on the left and the current W3C docs on the right. Very nice. I found them on Paul Parks’ website.

HTML Index: http://www.parkscomputing.com/html4/

CSS Index: http://meyerweb.com/eric/css/references/css2ref.html

You can't normally create alerts for SharePoint groups. Here's how:

1. E-mail enable the SharePoint group so that a distribution list/group is created in Active Directory.
2. Edit the properties of the group to change its Group Type to Security. Only security groups will show up in SharePoint's address book. They will show up as "domain groups" in SharePoint.
3. Give the domain group at least visitor permissions on the list that are you are creating the alerts for. Alerts won't be sent if the domain group doesn't have appropriate permissions. This will mean that you'll likely have both the SharePoint group and the domain group in the permissions list. Simply giving the SharePoint group permissions is not enough.
4. Then setup the alert and use the address book to locate the domain group. In the address book you'll see it with the form "DOMAIN\group name".
5. Now test out your alerts. If you have require approval turned on for the list, make sure you approve the items so alerts will be sent.

Paul Liebrand’s Weblog - Does your SharePoint alerts have the wrong time…? - This article has some nice debugging tips.

Microsoft SharePoint Team Blog - Important hotfixes for upcoming Daylight Savings Time (DST) change - September 19, 2007

Microsoft Support - List of products affected by daylight saving time

Microsoft Support - Daylight Saving Time Help and Support Center

Microsoft KB 934525 - Description of the security update for Windows SharePoint Services 3.0: October 9, 2007

Microsoft KB 939809 - Description of the update that addresses the issue in Windows SharePoint Services 3.0 in which items that use the Date and Time fields are off by one hour

Microsoft KB 956612 - Description of an update for Windows SharePoint Services 3.0 that applies to daylight saving time (DST) changes