Muckross House & Killarney National Park

Killarney, Co.Kerry 2011-02-19

ASP.NET LINQ Union Distinct not working

Using Union(....).Distinct() not producing a distinct list when unioning a list of complex objects.

CAUSE:
Union() and Distinct() don't know which member of the object to use in their comparisons.

SOLUTION:
1. - IEqualityComparer needs to be defined to specify what fields of the object to compare:

public class MyComplexObjectComparer : IEqualityComparer
{
public bool Equals(complexObject a, complexObject b)
{
return a.Id == b.Id;
}

public int GetHashCode(complexObject obj)
{
return obj.Id.GetHashCode();
}
}

2. - Pass this comparer into the Union:

.Union(lockedout, new MyComplexObjectComparer()).Distinct;


SOURCE:
http://blog.dreamlabsolutions.com/post/2009/06/23/Enumerable-Except-TSource-and-IEqualityComparer-a-little-help.aspx

IIS 6 Error - Port in use when binding a wildcard SSL to multiple sites

Port in use error occurs when 443 is set as SSL port on multiple site in IIS 6.

CAUSE:
SecureBindings metabase property is not set.

SOLUTION:
Run the following from cmd:

C:\Inetpub\AdminScripts\cscript.exe adsutil.vbs set /w3svc/SITEIDENTIFIER/SecureBindings ":443:HOSTHEADER"

where SITEIDENTIFIER and HOSTHEADER are replaced.


SOURCE:
http://www.sslshopper.com/article-how-to-configure-ssl-host-headers-in-iis-6.html

Photoshop CS4 – Fix : Error: 148:3

POSSIBLE CAUSE:
Flexnet Licensing Service not running

SOLUTION:
- Start->Run, type services.msc
- Find Flexnet Licensing Service and right-click
- Click Start if possible, otherwise click Properties, and set service to run automatically.

Source:
http://forums.adobe.com/thread/375447

Munster V London Irish - 110122

Munster V London Irish - 110122

ISS in partial eclipse of the sun

Source:
http://apod.nasa.gov/apod/ap110105.html

Earth Temperature Increases Mapped

Nasa's GISS Temperature Map:

Source:
http://earthobservatory.nasa.gov/Features/WorldOfChange/decadaltemp.php?src=eoa-features

Horslips - O2 - Dec 2010

Horslips - O2 - 101204

ASP.NET Datasets: Failed to enable constraints.

Got this error after changing the length of a column in the database:
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

CAUSE:
The table adapter column maxlength is not updated automatically.

SOLUTION:
Update the table adapter column maxlength manually in the properties window for that column in the dataset editor.

Source:
http://social.msdn.microsoft.com/Forums/en/Vsexpressvb/thread/27aec612-5ca4-41ba-80d6-0204893fdcd1

Horslips - Celtic note

Horslips - Celtic Note

Munster V Australia - 101116

Munster V Australia - 20101116

SQL SERVER – Fix : Error: 4064

SQL SERVER 2005 – Fix : Error: 4064 – Cannot open user default database. Login failed. Login failed for user.

CAUSE:
The default database for the user is not accessible, this stops the user from logging in.

SOLUTION:
- Login Prompt->Connection Properties Tab->Connect to database field
- Change the database name to master.
- Once logged in, update the user's default database:

ALTER LOGIN [user] WITH DEFAULT_DATABASE = master

Source:
http://blog.sqlauthority.com/2008/11/04/sql-server-fix-error-4064-cannot-open-user-default-database-login-failed-login-failed-for-user/

Minimalist Fantastic Four

Source (Tom Fowler):
http://www.comictwart.com/2010/11/minimal-fantastic-four-by-tom-fowler.html

Flush Photoshop CS4 preferences when freezing on startup

If Photoshop CS4 freezes on startup, or opens off-screen (into a multiple monitor ghost), you can flush the user preferences by renaming the preferences file:

C:\[User]\AppData\Roaming\Adobe\Adobe Photoshop CS4\Adobe Photoshop CS4 Settings\Adobe Photoshop CS4 Prefs.psp

Source:
http://www.wallpaperama.com/disp-post57.html

President Obama Inauguration on GigaPan

http://gigapan.org/gigapans/15374/

Space Shuttle Launch Pad on GigaPan

http://gigapan.org/gigapans/63782/

Quite simple really

Munster V Ospreys - 100918

Munster v Ospreys - 100918

Using LINQ to get a Distinct List

First, create a type comparer:

    public class ItemComparer : IEqualityComparer<Item>
    {
        #region IEqualityComparer<Item> Members
 
        public bool Equals(Item x, Item y)
        {
            return x.ItemID == y.ItemID;
        }
 
        public int GetHashCode(Item obj)
        {
            return obj.ItemID.GetHashCode();
        }
        #endregion
    } 

Then, use it as follows on a List items:

    IEnumerable<Item> distinctItems = 

          items.Distinct(new ItemComparer());
    items = distinctItems.ToList();

Munster V Aironi- 100904

Munster V Aironi - 100904