Tuesday, September 30, 2008

I'm online again!

I recently moved to a new apartment (in beautiful Frederiksberg) and have thus been without Internet for a couple of days - you know how it goes.

Then yesterday I received a letter from my ISP saying my Internet connection was switched on and that I could start using it. I didn't have time to try it then, and haven't until now. There were problems, however. The ISP (ComX) has a website where all "clients" to your Internet should be entered with their MAC address. I did that with my AirPort Express, using the MAC address that Airport Utility would show me, bu that didn't work. After reading a few forums and thinking and swearing, the solution was to use the right MAC address. Not meaning I "misspelled" the address, but apparently wireless routers have two MAC addresses - one for WAN and one for LAN. The one I saw in AirPort Utility was the LAN one, and the ISP wanted the WAN one...

But it works now!!!

Thursday, September 25, 2008

The group finally says hello!

After having been officially merged for a couple of months, Hello Group (formerly HelloWeb, HelloGroup, HelloBrand etc...) has released a web site!

Be sure to check it out here:

www.hellogroup.com

I find it pretty neat! I'm in one of the videos - see if you can spot me :-)

If you don't already know it, I do a lot of work for Hello Group, and I'm proud to say that I've been doing some of the finishing touches on the site. I've developed a new plugin for the site - which is running on the Wordpress blogging engine.

Saturday, September 06, 2008

Auto XML sorted

I've been fighting a bug for some hours now bug have finally found the solution!

Here's the deal: I've developed a tool to import the contents of some files into a database. Furthermore there is a UI for CRUD'ing the now database content. The problem was, that when I imported from more than 10 files (don't know why this exact number, it's purely empirical) the data would show up pretty strange. It should have a format like this:

1 (count: 34)
3 (count: 54)
2 (count: 20)

But instead it was showing:

1 (count: 1)
2 (count: 1)
1( count: 1)
1 (count: 1)
3 (count:1)
... etc.

Weird!

At first I was looking at the import tool - I must have made an error somewhere, but no. The solution was to sort the data! The stored procedure selecting the data uses FOR XML AUTO to generate a hierachical structure, and somehow that twisted the data. But after adding "ORDER BY ColumnName" to the SQL it comes out right!

I don't understand why yet - and can't find any other posts regarding the same topic....