"Wanted" - 10/10

Just came back form the cinema and wondeful experirience watching Wanted with James McAvoy, Morgan Freeman and Angelina Jolie. A must see!

Browser compatible InfoPath form linked to a web service

I had to create an InfoPath form to submit data to a SQL 2005 database and was surprised you can't submit to SQL directly if you run the form from the web browser. Instead you need to write a web service which will link InfoPath form and SQL database.

So I write a simple webservice and create the InfoPath form which I link to this service. Run the form from InfoPath to test it; submit data successfully and checked on the database that the web service done its bit. Published the form to MOSS 2007 so everything done... Not!

I had to:

• In the form options
  - under Compatibility tick "design a form template that can be opened in a browser or InfoPath and enter URL of the MOSS with InfoPath Form Services;
  - under Browser Choose to show toolbars and Submit command;
• In Tools / Data Connection convert the data connection and store it on the same MOSS (link type Relative to site collection);
• In Tools / Submit Options tick "Allow users to submit this form" and set it to send form data to a web service;
• Publish form to the SharePoint server.
• In the SharePoint library on the lib settings go to Advanced Settings and make sure that under Browser-enabled Documents that browser-enabled docs are displayed as a web page.

Now it's done. I think... It works anyway...

Team Fortress 2 - Excellent game

Wish the day had more hours. This and incredible game with stunning visual style. The game has nine well balanced character classes: Spy, Pyro, Soldier, Heavy, Medic, Sniper, Demoman, Scout and Engineer each with different abilities which gives you lots to try and bound to have few favourites. There's also great variety of maps. I can see myself spending many many hours playing this game in the comming months...

Can't submit data direct to SQL Server using browser-compatible InfoPath form

Apparently you need to write a web service that will accept the data on the SQL Server's behalf. Not happy!

Portal song "Still Alive" in the Rock Band

As I was playing Rock Band with my kids last night I was very pleasantly surprised to see "Still alive" as one of the songs in the list of songs. Absolutely brilliant! I've been humming it for a week now and to be able to play it on Rock Band it's a real treat. Well chuffed...

Download and print Lyrics to Still Alive from Gamespot site