I wrote the following method which handled this perfectly:

private bool CheckItemExists(SPList list, SPFolder folder, string urlValue)
{
SPQuery query = new SPQuery();
if (folder != null)
{
query.Folder = folder;
}
query.Query = @”
<Where>
<Eq>
<FieldRef Name=’URL’ />
<Value Type=’Text’>” + urlValue + @”</Value>
</Eq>
</Where>”;
SPListItemCollection found = list.GetItems(query);
return (found.Count > 0);
}

If you have however done this, then when you clean up all the data from the database make sure you delete the record in the Categories database, and specifically the CategoriesData table. You will find the GUID from the error that keeps popping up in in the ‘data’ column of this database. Once you delete the problem row you K2 environment should return to normal (though you might need to restart the K2 service). This will also fix issues with the SmartObject service, as this also will NOT work whilst there is a rogue row in the CategoriesData table.

I thought this was going to be an easy configuration change, however in the end this required a bit of javascript injected into the page.

Basically all you need to do is add the following to the masterpage and set the correct value for the locale that you want:

<script language=”javascript” type=”text/javascript”>
L_Language_Text = 3081;
</script>

Once this is added the default dictionary is changed. I have included a table below of the common dictionaries for the various English languages. For a complete list of locales check out the following site here: http://msdn.microsoft.com/en-us/goglobal/bb964664.

English – United States – 1033
English – United Kingdom – 2057
English – Australia – 3081
English – Belize – 10249
English – Canada – 4105
English – Caribbean – 9225
English – Hong Kong SAR – 15369
English – India – 16393
English – Indonesia – 14345
English – Ireland – 6153
English – Jamaica – 8201
English – Malaysia – 17417
English – New Zealand – 5129
English – Philippines – 13321
English – Singapore – 18441
English – South Africa – 7177
English – Trinidad – 11273
English – Zimbabwe – 12297

 In order to fix this you will need to do the following:

Go to > Local Security Policy- > Local Policies -> User Rights Assignment on the server you are trying to install on.

Assign your logged in account (eg [domain]/[username]) the following rights:

• Back up files and directories
• Debug Programs
• Manage auditing and Security log
• Restore files and directories
• Take ownership of files or other objects

Once you have done this, log out then log back in again.
After this the installer should now work!

<ListBox ItemsSource=”{StaticResource MyData}”>
  <ListBox.ItemTemplate>
    <DataTemplate>
      <TextBlock>
        <TextBlock.Text>
          <MultiBinding  StringFormat=”{}{0} — Now only {1:C}!”>
            <Binding Path=”Description”/>
            <Binding Path=”Price”/>
          </MultiBinding>
        </TextBlock.Text>
      </TextBlock>
    </DataTemplate>
  </ListBox.ItemTemplate>
</ListBox>

Thanks to http://msdn.microsoft.com/en-us/library/system.windows.data.bindingbase.stringformat.aspx

Here is my basic implementation:

<Style.Triggers>
    <Trigger Property=”Text” Value=””>
        <Setter Property=”Visibility” Value=”Collapsed” />
    </Trigger>
    <Trigger Property=”Text” Value=”{x:Null}”>
        <Setter Property=”Visibility” Value=”Collapsed” />
    </Trigger>
    <Trigger Property=”Visibility” Value=”Visible”>
        <Trigger.EnterActions>
            <BeginStoryboard>
                <Storyboard>
                    <DoubleAnimation Storyboard.TargetProperty=”Opacity” Duration=”00:00:00″ BeginTime=”00:00:00″ From=”0.0″ To=”1.0″ />
                    <DoubleAnimation Storyboard.TargetProperty=”Opacity” Duration=”00:00:03″ BeginTime=”00:00:10″ From=”1.0″ To=”0.0″ />
                </Storyboard>
            </BeginStoryboard>
        </Trigger.EnterActions>
    </Trigger>
</Style.Triggers>

ie this does NOT work:

SPListItemCollection productMatches = currentWeb.Lists[“SomeList”].GetItems(query);
productMatches[0][“UpdatedValue”] = true;
productMatches[0].Update();

Where as this DOES work:

SPListItemCollection productMatches = currentWeb.Lists[“SomeList”].GetItems(query);
SPListItem someItem = productMatches[0];
someItem[“UpdatedValue”] = true;
someItem.Update();

Funny how such simple things can elude you for so many years…

Super Size Me Screen Shot

I am very excited to have submitted my very first application to the Windows Phone 7 marketplace. Over the next few months I intend on creating some more and adding them to the marketplace. As a result some of my SharePoint work I am doing and have been working on is going to be on the back burner a bit.

What this does mean though is that I am (and have been) learning a whole lot of new things around the Windows Phone 7 development experience – especially around Silverlight, Azure and Expression – so I intend on doing some posts to this blog around some of my discoveries.

If you are interested in reading about my very first application you can check out my company website Cherry Byte Software for more information. Like here, I plan on doing regular updates there on the applications that are coming out!

Object of type ‘Microsoft.VisualStudio.TestTools.TestTypes.Unit.UnitTestAdapterContext’ cannot be converted to type ‘Microsoft.VisualStudio.TestTools.UnitTesting.TestContext’

Solution – the assembly Microsoft.VisualStudio.QualityTools.UnitTestFramework.dll is using the wrong version (9.0.0.0 instead of 10.0.0.0). Simply remove the reference toMicrosoft.VisualStudio.QualityTools.UnitTestFramework.dll and then add the reference again but using the 10.0.0.0 version!