• Sharpe's Enemy (Bernard Cornwell) & Sharpe's Sword (Bernard Cornwell)

    More Sharpe! This is a big series (21 Novels not counting 2 extra short stories) and I seem to be working my way through it. The trouble will be when I can’t remember which books I’ve read when I see them in the second hand book shop. I guess I’ll have to keep a list on my PDA.

    Anyway, the story continues. In Sharpe’s Enemy Sharpe finally defeats his original enemy from the first books. Sergeant Hakeswill has deserted and joined a band of renegades formed from all opposing sides (the historical note actually says there really was a band of deserters at the time!). The deserters capture a village and the wife of a British nobleman and Sharpe is sent to rescue her. That would be far to simple a task for Sharpe so of course it gets a little more complicated. He makes the first successful battle use of rockets in this book and gives Napoleon’s forces a surprise or two.

    In Sharpe’s Sword he begins by capturing a French officer who says he is a Captain but is really a much feared General. He escapes and Sharpe’s duty is to capture him once more. There are a few twists and turns, some clever camouflage, yet more romance and yet more misery. I have to wonder what rank Sharpe ends up as – I seem a good number of books away from Waterloo and I’m not sure how many ranks are left! I’ll let you know when I get there.


  • Harlequin (Bernard Cornwell) & Vagabond (Bernard Cornwell)

    I enjoyed Uhtred in Bernard Cornwell’s Saxon Series, go forwards several hundred years and join Thomas of Hookton on his equally enjoyable adventures.

    Thomas is an English Archer who’s father was a village priest. The story begins with the death of his father and the destruction of Thomas’s home village by European raiders and follows his journey first for vengeance but equally to discover the truth about his family’s origins. He discovers his family was said to be the keepers of the Holy Grail and circumstances conspire to make him search for it. There are plenty of twists along the way, a dash or two of romance, death (well, he is an archer in the middle of a war) and valour.

    Uhtred from the Saxon series was a sometimes like-able, oftentimes detestably violent person. Thomas is much more like able as a character. Perhaps even more pleasant that Richard Sharpe in the Sharpe series. He is no less realistic though and I can’t help but look out for the third book in the series “Heretic” – Does Thomas find his Grail?

    As I read more of Bernard Cornwell’s books I am impressed by the historical settings. The end of each book puts in place some divisions between fact and fiction making reading his books a little bit of education as well as a pleasure.


  • creating a new column in a MySQL select query

    I’ve been really busy since my last post (a whole month without a post!). Work is exceptionally busy and work comes first. Even my reading has slowed down a bit. I have several things waiting to be posted when I get time to write about them – including the first ever competition for this blog! You’ll have to check back over the next week or two to find out what that’s all about, in the mean time this post is all about…

    i-049902d1550e456dd21b47b1967a27cb-mysql_100x52-64.gif

    “creating a new column in a MySQL select query”

    So, here I am manipulating some data from a supplier to make it work with our internal business systems. Essentially I had to work out how much a kitchen cabinet would cost given an “assembly list”, “component list”, “decision list” and of course “cup of coffee”.

    Assembly list tells me that each unit needs a cabinet and a door. There are lots of door colours and lots of cabinet colours. These options are all in the component list which tells me the price of each door. The decision list is my own creation and says “build me a unit using a Maple door and a Maple cabinet”. “cup of coffee” feeds my habit while I code. So far, so good.

    Once I’ve created a list of units using maple doors and maple cabinets, I then want to create another list of oak doors and oak cabinets. Join them all together and I have a complete list of cabinets that customers can buy. I needed a way of identifying which cabinet was built with which options and for the life of me I couldn’t remember how to do it. I needed to create an additional column in my query that would record what “decision list” row had been used for this build.

    The answer is of course obvious once you know it:
    Select “StevesDecision” as StevesColumnName, FirstBuildUpStaticTable.Material, SUM(`Gross weight`) As GWeight, and so on.

    “StevesDecision” becomes the content of each row and “StevesColumnName” becomes the column name. All the rest of the select… line remains the same.


Search this site


Free apps

  • birthday.sroot.eu – Your birthday or other celebration date based on [years on other planets] / [how many seconds/days] / [how far you’ve travelled around the sun]
  • stampulator.sroot.eu – Calculates the combination and how many 1st, 2nd, large 1st and large 2nd class Royal Mail stamps you need on large envelopes and packets

Recent posts


Archives


Categories