Tomorrow I have a day out – I am doing some work over at pymble… I am closely supervising the work of a programmer, slowly bringing him to the point of working out what the product needs to do, and how it needs to work. In this case it is best that I just supervise the work mamking sure it goes in the right general direction, tuning things as required.

I had a minor problem today when I was working out how to export a database from the TeamTrack Client problem. I wanted to do a history query and then save that as XML. The problem was that it just did not work. Debugging things I found the answer… The WebService was not returning any data. Then I remembered – the was a bug in the database, and whilst I fixed the stored procedure on the old database, it was not there on the new one since the bug report and the new database crossed in transit… The next database will have the fix… It just took me a minute to fix this database too… A simple case of removing an ‘INNER JOIN’ that was not needed.

[Dumb me was the cause of this one. I have a ‘Vehicle_ID’ and an ‘IMEI_ID’. Both are supposed to be the same, but I refer to them differently in different places. I probably should just rename everything to Vehicle_ID and be done with it. Anyway the programmer did not realise this and thought he needed to link the two using another table which he though provided the link. A simple problem with a convoluted description]

It would appear that LED’s are appearing everywhere… And so are solar cells. Personally I think the solar lights in the garden are one of the greatest wastes of money. I have just found a product that looks like it may not be a waste… Solar powered lit paving bricks. They are not cheap at US$$60 but they are uniqie and do not need any wiring. They just come on when it goes dark. Great idea…