{"id":738,"date":"2006-08-01T18:26:00","date_gmt":"2006-08-01T08:26:00","guid":{"rendered":"http:\/\/new.radio-active.net.au\/web3\/738\/"},"modified":"2014-10-10T12:20:43","modified_gmt":"2014-10-10T01:20:43","slug":"738","status":"publish","type":"post","link":"http:\/\/www.radio-active.net.au\/web3\/738","title":{"rendered":""},"content":{"rendered":"<p>Tomorrow I have a day out &#8211; I am doing some work over at pymble&#8230; 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. <\/p>\n<p>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&#8230; The WebService was not returning any data. Then I remembered &#8211; 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&#8230; The next database will have the fix&#8230; It just took me a minute to fix this database too&#8230; A simple case of removing an &#8216;INNER JOIN&#8217; that was not needed. <\/p>\n<p>[Dumb me was the cause of this one. I have a &#8216;Vehicle_ID&#8217; and an &#8216;IMEI_ID&#8217;. 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]<\/p>\n<p>It would appear that LED&#8217;s are appearing everywhere&#8230; 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&#8230; Solar powered lit paving bricks. They are not cheap at <a href=\"http:\/\/www.herringtoncatalog.com\/y354.html\">US$$60<\/a> but they are uniqie and do not need any wiring. They just come on when it goes dark. Great idea&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tomorrow I have a day out &#8211; I am doing some work over at pymble&#8230; 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 &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"http:\/\/www.radio-active.net.au\/web3\/738\">  Read More &raquo;<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/s5cfmK-738","_links":{"self":[{"href":"http:\/\/www.radio-active.net.au\/web3\/wp-json\/wp\/v2\/posts\/738"}],"collection":[{"href":"http:\/\/www.radio-active.net.au\/web3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.radio-active.net.au\/web3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.radio-active.net.au\/web3\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.radio-active.net.au\/web3\/wp-json\/wp\/v2\/comments?post=738"}],"version-history":[{"count":0,"href":"http:\/\/www.radio-active.net.au\/web3\/wp-json\/wp\/v2\/posts\/738\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.radio-active.net.au\/web3\/wp-json\/wp\/v2\/media?parent=738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.radio-active.net.au\/web3\/wp-json\/wp\/v2\/categories?post=738"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.radio-active.net.au\/web3\/wp-json\/wp\/v2\/tags?post=738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}