Today I was mainly still working on the SQL queries for inserting a new category on my photo website. I did get a bit further with it, hopefully can get that working tomorrow.
Also in the morning I watched 'Me too' with Ben. Granny Murray kept doing giant green fees everywhere, and the woman who cleans the buses even fanned one into her own face, the weirdo! Also Granny Murray took some kids (probably 3-5yrs old) to see the fireworks (at Edinburgh Castle I think) at 11pm, then later they were having a barbeque back at Granny Murray's place, so probably 12am I guess. I'm surprised the kids didn't get sleepy, maybe Granny Murray gave them some of whatever it is she's on to keep them awake.
A dog knocked over some paint and then made dog footprints in red paint around the bus depot and inside a bus, but weirdly the woman who has to clean the buses didn't seem very bothered. She did like dancing with a mop though instead of doing her job. What on earth the bus driver who was driving his bus into the depot thought when he saw her dancing with a mop, I don't know, but I can take a guess. The fireworks display was pretty good though.
After lunch I went on Animal Crossing for a bit, and I also went in the garden later in the afternoon for a bit, though it was very windy and quite cold.
In the evening I watched 'The Black Pirate' with Mac and Ben, and the last episode of season 4 (part 1) of Trashelstar, which was actually good! (It would have made quite a good point to end the series as well I think).
The weather today was cloudy and sunny and windy.
Food
Breakfast: 2x crumpets with I can believe it's nae butter jimmy and honey; cup o' tea.
Lunch: Smoked Barvarian ham with crunchy salad sandwich; a few roast chicken flavour crisps; clementine; slice of jam and buttercream sponge sandwich cake; chocolate digestive bar; cup o' tea.
Dinner: Shepherds pie; broccoli; carrots; tomato ketchup. Pudding was Green's Lemon Meringue cake mix (made up) with spleenvap. Coffee.
Tuesday, 7 April 2009
Monday, 6 April 2009
Watching CBeebies
This morning I watched Ceebeebies with Ben, vacuumed my room and also did a bit of work on my website, still working on the SQL queries for inserting nodes into a hierarchy. I just don't seem to be able to get my head around how to insert a new node as a parent of an existing node.
One of the TV programs I watched with Ben was called 'Me Too', it was totally skill and had Jane McCarry as 'Granny' Murray, and she was constantly doing weird skill faces. They also had a weird bloke who works on a train and managed to spill a chocolate mousse all over someone's Sari, and a trumpet player who looked like Michael Jackson. Unfortunately since it was on Digital TV, and not on Mac's comp I couldn't do any screenshots.
After lunch I went on Animal Crossing (and bought a silver fishing rod from Nooks), did more work on my website, and also went out in the garden for a bit with Ben and saw quite a few different flies, including a couple of saw flies. I also had to cook dinner for me, Mac and Ben as Clare and Brian were going out.
After dinner I watched an episode of The Equalizer, did a bit more website stuff, and then watched Battlestar Trashlactica with Moc.
Food
Breakfast: Bowl of crunchy nut cornflakes; cup o' tea.
Lunch: 2x cheese on toasts; clementine; chocolate digestive bar; Sainsbury's caramel chocolate; cup o' tea.
Dinner: Nasi Goreng; noodles. Pudding was a big chocolate choc chip cookie. Coffee; Sainsbury's caramel chocolate.
Supper: Hot chocolate with Dooleys; nice biscuit; dark chocolate digestive biscuit.
One of the TV programs I watched with Ben was called 'Me Too', it was totally skill and had Jane McCarry as 'Granny' Murray, and she was constantly doing weird skill faces. They also had a weird bloke who works on a train and managed to spill a chocolate mousse all over someone's Sari, and a trumpet player who looked like Michael Jackson. Unfortunately since it was on Digital TV, and not on Mac's comp I couldn't do any screenshots.
After lunch I went on Animal Crossing (and bought a silver fishing rod from Nooks), did more work on my website, and also went out in the garden for a bit with Ben and saw quite a few different flies, including a couple of saw flies. I also had to cook dinner for me, Mac and Ben as Clare and Brian were going out.
After dinner I watched an episode of The Equalizer, did a bit more website stuff, and then watched Battlestar Trashlactica with Moc.
Food
Breakfast: Bowl of crunchy nut cornflakes; cup o' tea.
Lunch: 2x cheese on toasts; clementine; chocolate digestive bar; Sainsbury's caramel chocolate; cup o' tea.
Dinner: Nasi Goreng; noodles. Pudding was a big chocolate choc chip cookie. Coffee; Sainsbury's caramel chocolate.
Supper: Hot chocolate with Dooleys; nice biscuit; dark chocolate digestive biscuit.
Sunday, 5 April 2009
I bought a(nother) crown!
This morning I woke up at 7am, then after breakfast went on Animal Crossing. There was a crown in Able Sister's, but it cost a million bells. I only had about 850,000 bells, so that meant I had to try and earn 150,000 bells today so I could purchase the crown (Able Sister's change their stock every day, so I wouldn't be able to buy the crown if I waited until I had got 1 million bells through my normal earnings).
After Church I carried on going on Animal, and also after lunch, until probably about 3.00pm or maybe 3.30pm when I had finally earned enough to buy the crown. I got most of the money from fishing (mainly in the sea) and also got a bit from selling oranges (100 bells ea.) and coconuts (500 bells ea.)
When I had finally got my crown (and bought some stuff from Nooks), I saved and quit Animal Crossing, then went in the garden for a bit. I saw a dung fly eating a fly, I got a couple of photos of it, but then it flew away. I also saw a Weevil on a window sill, so I took some photos of that. There wasn't much else to see in the garden really.
I had a scone, and then me, Ben and Mac watched Super Mario Bros, the defining point of Dennis Hopper's career. When Mario, Luigi, and a bunch of kidnapped girls from Brooklyn are sliding down a frozen pipe on a giant matress, I thought "It can't get much better than this", then it cuts to some goombas sliding down the pipe on another matress behind them - it just got even better!!! The only bad thing about the film is that it doesn't have a sequel. Luigi didn't look much like Luigi either, but that's not too much of a problem.
After that we had tea, then I went on Animal Crossing again and went to the HRA headquarters in the city. I had been awarded room of the month again, for the third month running. This time though, it was basement that was selected rather than my ground floor. The theme this month was 'cuteness', so it seems that the Pave set must be cute. I also did some more fishing, and caught a new fish - a surgeon fish.
Then I went on my comp and sorted the pics I'd taken today.
The weather today was a mixture of cloud and sunshine.
Food
Breakfast: Bowl of Crunhy nut cornflakes; cup o' tea.
After church snack: Dark chocolate digestive; malted milk; coffee.
Dinner: Chilli con carne; rice; grated cheese. Pudding was a mostly frozen vanilla mousse with hardly any raspberry non ripple. Coffee.
Afternoon snack: Scone with I can believe it's not butter and raspberry jam; cup o' tea.
Tea: 2x cheese on toasts; clementine; breakaway; cup o' tea.
After Church I carried on going on Animal, and also after lunch, until probably about 3.00pm or maybe 3.30pm when I had finally earned enough to buy the crown. I got most of the money from fishing (mainly in the sea) and also got a bit from selling oranges (100 bells ea.) and coconuts (500 bells ea.)
When I had finally got my crown (and bought some stuff from Nooks), I saved and quit Animal Crossing, then went in the garden for a bit. I saw a dung fly eating a fly, I got a couple of photos of it, but then it flew away. I also saw a Weevil on a window sill, so I took some photos of that. There wasn't much else to see in the garden really.
I had a scone, and then me, Ben and Mac watched Super Mario Bros, the defining point of Dennis Hopper's career. When Mario, Luigi, and a bunch of kidnapped girls from Brooklyn are sliding down a frozen pipe on a giant matress, I thought "It can't get much better than this", then it cuts to some goombas sliding down the pipe on another matress behind them - it just got even better!!! The only bad thing about the film is that it doesn't have a sequel. Luigi didn't look much like Luigi either, but that's not too much of a problem.
After that we had tea, then I went on Animal Crossing again and went to the HRA headquarters in the city. I had been awarded room of the month again, for the third month running. This time though, it was basement that was selected rather than my ground floor. The theme this month was 'cuteness', so it seems that the Pave set must be cute. I also did some more fishing, and caught a new fish - a surgeon fish.
Then I went on my comp and sorted the pics I'd taken today.
The weather today was a mixture of cloud and sunshine.
Food
Breakfast: Bowl of Crunhy nut cornflakes; cup o' tea.
After church snack: Dark chocolate digestive; malted milk; coffee.
Dinner: Chilli con carne; rice; grated cheese. Pudding was a mostly frozen vanilla mousse with hardly any raspberry non ripple. Coffee.
Afternoon snack: Scone with I can believe it's not butter and raspberry jam; cup o' tea.
Tea: 2x cheese on toasts; clementine; breakaway; cup o' tea.
Saturday, 4 April 2009
Taking photos and watching films
This morning I woke up after 9am again, and also had a headache. After breakfast I went in the garden, but didn't see any insects. I checked my email and Andy Rouse's blog, then went to bed as my headache was too painful.
After lunch I took some photos in the garden, then went on a walk up the Hill on the way to Lubenham and back with Clare, Brian, Ben and Jon. I took some more photos in the garden, then went on my comp for a bit. I checked my email again and the canon lens forum on dpreview and also did a bit of work on my photo website. I'm still trying to figure out the SQL queries for adding a parent node to the database using the nested sets model for hierarchical data.
After dinner I watched True Lies with Mac, most of it was quite good, but not amazing, but then near the end Arnie fires a missile with bloke on it through a hole he has shot in a building into a helicopter full of bad guys on the other side. Just before he fires the missile, he says to the bloke "You're fired". Totally amazing! It also had a totally skill bloke in it.
After that I watched Snatch Wars, which was really funny.
Food
Breakfast: Bowl of Crunchy nut cornflakes; cup o' tea.
Lunch: Fresh baked bread maker bread with cheese; clementine.
Dinner: 2½ bits of SFC Chicken; salt; potatoes; baked beans. Pudding was quite a bit of posh ice cream; 2x pear halves; 2x trifle sponges; chocolate sauce (I didn't have it all at once as it wouldn't have fit in the bowl). Coffee; Quality Street; Sainsbury's caramel chocolate.
Supper: Dark chocolate digestive; malted milk; cup o' tea.
After lunch I took some photos in the garden, then went on a walk up the Hill on the way to Lubenham and back with Clare, Brian, Ben and Jon. I took some more photos in the garden, then went on my comp for a bit. I checked my email again and the canon lens forum on dpreview and also did a bit of work on my photo website. I'm still trying to figure out the SQL queries for adding a parent node to the database using the nested sets model for hierarchical data.
After dinner I watched True Lies with Mac, most of it was quite good, but not amazing, but then near the end Arnie fires a missile with bloke on it through a hole he has shot in a building into a helicopter full of bad guys on the other side. Just before he fires the missile, he says to the bloke "You're fired". Totally amazing! It also had a totally skill bloke in it.
After that I watched Snatch Wars, which was really funny.
Food
Breakfast: Bowl of Crunchy nut cornflakes; cup o' tea.
Lunch: Fresh baked bread maker bread with cheese; clementine.
Dinner: 2½ bits of SFC Chicken; salt; potatoes; baked beans. Pudding was quite a bit of posh ice cream; 2x pear halves; 2x trifle sponges; chocolate sauce (I didn't have it all at once as it wouldn't have fit in the bowl). Coffee; Quality Street; Sainsbury's caramel chocolate.
Supper: Dark chocolate digestive; malted milk; cup o' tea.
Friday, 3 April 2009
Trying to take photos of flies
I got up quite late today, after 9am. I checked my email and did a little work on my website, then it was lunch time.
After lunch I played on Animal Crossing, then I went in the garden for a bit. I did a little bit more work on my website, then went in the garden again as the sun had now come out. There were a couple of flies on the variegated Holly, but when I came back outside with my camera, they were gone. I did a little bit more work on my website, and then checked my email again.
I had previously emailed Colchester Camera Repair Service, who are listed as dealing with canon repairs and parts on canon's website, to see if I could get a spare of the ring used to mount the Canon Macro Twin Lite MT-24EX flash heads to the end of the lens. They had replied to me saying
So I contacted Canon through the support form on their website, and they emailed me back to say
The second telephone number they gave is the Colchester Camera Repair Service, so I didn't bother contacting them, since they had already said they couldn't get that part. I phoned up the Canon Sales Department, but they said they only sell items available on Canon's website, not spare parts. They gave me the telephone number for Canon Spare Parts/Repair, 01483 776060.
So I phoned Canon Spare Parts/Repair, but they said they only deal with business equipment like photocopiers, and I should phone Lehmanns on 01782 413611. I didn't bother phoning Lehmanns because 1) If Colchester Camera Repair Service can't get the spare part themselves, I wouldn't have thought Lehmanns could get it either, and 2) I was only curious about whether the part was available and if so, how much it cost.
Probably about 4pm I went in the garden to try and take some photos of flies. Although I stayed out there until about 6pm, I'll be lucky if I got one decent photo. I found the flies liked licking the new leaves that are sprouting on the Goat Willow/Great Sallow bush, but quite often when I grabbed on to the twig they were on, they would fly off.
If I managed to grab the branch they were on without them flying off, quite often by the time I'd find where the fly was in the viewfinder, the fly wasn't there anymore and had flown off. If I did get a co-operative fly, it was still hard to get any shots as they were constantly walking round, and since they would walk to the other side of the bud rather than just walk in a straight line, it meant you would have to let go of the branch then grab it again from a different angle, or else just get a bum shot.
I did find a dung fly who didn't mind me constantly re-grabbing the branch it was on as it moved out of view, and it even walked off the branch onto my hand. Unfortunately I don't really like insects crawling on me, though it was weird because I could see it walking on and licking (yuck!) my hand, but couldn't really feel it.
After dinner I watched Simpsons with Mac and Ben, then I went in the garden to see if I could find any flies that had settled down for the night. I didn't see any, though I did see a bug, so I went back inside and got my camera, but then when I went back in the garden it was gone.
I sorted the photos I took today, did a bit more website stuff, then played on Rez for the PS2 for a bit, which totally vibrated my hands.
The weather today was overcast all morning, then nice and sunny in the afternoon.
Food
Breakfast: Pink grapefruit toast sandwich; cup o' tea.
Lunch: Mature cheddar cheese sandwich; apple; chocolate digestive bar; cup o' tea; a couple of pieces of Cadbury's Dairy Milk Turkish.
Dinner: 2x Salmon & (I got a Mill out the) Dill (and I'm still on the grind) fishcakes; potato; peas; Tomato Ketchup. Pudding was microwave sponge with strawberry jam & custard. Coffee; Sainsbury's caramel chocolate.
After lunch I played on Animal Crossing, then I went in the garden for a bit. I did a little bit more work on my website, then went in the garden again as the sun had now come out. There were a couple of flies on the variegated Holly, but when I came back outside with my camera, they were gone. I did a little bit more work on my website, and then checked my email again.
I had previously emailed Colchester Camera Repair Service, who are listed as dealing with canon repairs and parts on canon's website, to see if I could get a spare of the ring used to mount the Canon Macro Twin Lite MT-24EX flash heads to the end of the lens. They had replied to me saying
Unfortunately you would need to contact Canon for the part you require as we cannot obtain them
So I contacted Canon through the support form on their website, and they emailed me back to say
I can give you the number of our sales department who may be able to help you. I will also give you the number of one of our repair centres who deal with spare parts and you may be able to purchase one from them.
Our sales department contact number is 0800 121 6341
Our repair centre dealing with spare parts contact number is 01206 843322
The second telephone number they gave is the Colchester Camera Repair Service, so I didn't bother contacting them, since they had already said they couldn't get that part. I phoned up the Canon Sales Department, but they said they only sell items available on Canon's website, not spare parts. They gave me the telephone number for Canon Spare Parts/Repair, 01483 776060.
So I phoned Canon Spare Parts/Repair, but they said they only deal with business equipment like photocopiers, and I should phone Lehmanns on 01782 413611. I didn't bother phoning Lehmanns because 1) If Colchester Camera Repair Service can't get the spare part themselves, I wouldn't have thought Lehmanns could get it either, and 2) I was only curious about whether the part was available and if so, how much it cost.
Probably about 4pm I went in the garden to try and take some photos of flies. Although I stayed out there until about 6pm, I'll be lucky if I got one decent photo. I found the flies liked licking the new leaves that are sprouting on the Goat Willow/Great Sallow bush, but quite often when I grabbed on to the twig they were on, they would fly off.
If I managed to grab the branch they were on without them flying off, quite often by the time I'd find where the fly was in the viewfinder, the fly wasn't there anymore and had flown off. If I did get a co-operative fly, it was still hard to get any shots as they were constantly walking round, and since they would walk to the other side of the bud rather than just walk in a straight line, it meant you would have to let go of the branch then grab it again from a different angle, or else just get a bum shot.
I did find a dung fly who didn't mind me constantly re-grabbing the branch it was on as it moved out of view, and it even walked off the branch onto my hand. Unfortunately I don't really like insects crawling on me, though it was weird because I could see it walking on and licking (yuck!) my hand, but couldn't really feel it.
After dinner I watched Simpsons with Mac and Ben, then I went in the garden to see if I could find any flies that had settled down for the night. I didn't see any, though I did see a bug, so I went back inside and got my camera, but then when I went back in the garden it was gone.
I sorted the photos I took today, did a bit more website stuff, then played on Rez for the PS2 for a bit, which totally vibrated my hands.
The weather today was overcast all morning, then nice and sunny in the afternoon.
Food
Breakfast: Pink grapefruit toast sandwich; cup o' tea.
Lunch: Mature cheddar cheese sandwich; apple; chocolate digestive bar; cup o' tea; a couple of pieces of Cadbury's Dairy Milk Turkish.
Dinner: 2x Salmon & (I got a Mill out the) Dill (and I'm still on the grind) fishcakes; potato; peas; Tomato Ketchup. Pudding was microwave sponge with strawberry jam & custard. Coffee; Sainsbury's caramel chocolate.
Thursday, 2 April 2009
Not a lot
This morning I checked my email and the websqueeze, then did some more work on the query I was working on yesterday, changing it so I didn't need to specify the node depth and the query would find out the depth itself. I also put the washing out in the garden and had a look for insects a couple of times, but didn't see any.
After that I went on Animal Crossing for a bit, ate lunch, then went on Animal a bit more. After that I posted some pogs to someone in Brazil who emailed me about doing a swap. I used the Royal Mail online postage printing, which I was very impressed with. The process was simple and straight forward, and even got me to fill out and print a customs declaration automatically. It took me a while to go through the process, but probably 100x faster than going to the post office. If you used the service regularly and had your address and credit card details saved you could probably complete the process very quickly.
After that I was listening to HFM and they had a person promoting 'healthy chocolate' on Moley's show. I looked it up on the pinternet and ebay, it's very expensive at about £1 for a 6g square!!! As far as I can tell it probably is healthier than normal chocolate, but not worth the huge premium over other high coacoa dark chocolates, and probably not as amazing and healthy as the Oxcai reps make out.
I read Is Oxcai A Scam? and the first and last couple of pages of Xocai - healthy chocolate or just another MLM scam. Listening to the radio broadcast, what I found interesting was when Moley asked the rep why it wasn't available to buy in shops, the rep just said that the product creator had already made a healthy chocolate before, and sold it in shops in the US and it was a great success with $383,000,000 in sales (something like that anyway). She said the creator wanted to create a really healthy high anti-oxidant chocolate, and no process existed so they had to develop it themselves and got a patent on it. And because the chocolate is cold pressed you don't loose all the goodness from the coacoa like you do with traditional chocolate, which is heated.
So she didn't answer the question at all, just tried to sell the product, kind of like how no Oxcai reps would answer the questions in the thread at 4networking about Oxcai's patent or independent trials showing Oxcai's healthy benefits.
After that I edited some photos.
After dinner I tried to rip my Tetris CDS, which arrived today. First of it made the CD drive go really loud and vibratey, so I had to restart my PC as the CD drive wouldn't eject. After that Exact Audio Copy (EAC) would just quit when I tried to extract the CD. I downloaded the latest version but still had the same problem. So I loaded up my IE6 virtual machine and downloaded EAC on that. I couldn't be bothered getting LAME set up with the best settings, so I just ripped the CD to FLAC and then copied it over to My Music.
Then I watched Lost with Mac and Ben and The Office (US) with Mac. After that I sorted some photos, checked my email and the Luminous Landscape.
The weather today was overcast all day except from about 5.30pm-6.00pm it was sunny. In the morning it was a bit foggy as well.
Food
Breakfast: Pink grapefruit marmalade toast sandwich; cup o' tea.
Lunch: Mature cheddar cheese with crunchy salad sandwich; 2x small clementines; slice of chocolate swiss roll; breakaway; cup o' tea.
Dinner: 2x sausage rolls; mashed potato; baked beans. Pudding was Jamaica Ginger cake with golden syrup and custard. Coffee.
Supper: Crinckle crunch; choc chip cookie; coffee.
After that I went on Animal Crossing for a bit, ate lunch, then went on Animal a bit more. After that I posted some pogs to someone in Brazil who emailed me about doing a swap. I used the Royal Mail online postage printing, which I was very impressed with. The process was simple and straight forward, and even got me to fill out and print a customs declaration automatically. It took me a while to go through the process, but probably 100x faster than going to the post office. If you used the service regularly and had your address and credit card details saved you could probably complete the process very quickly.
After that I was listening to HFM and they had a person promoting 'healthy chocolate' on Moley's show. I looked it up on the pinternet and ebay, it's very expensive at about £1 for a 6g square!!! As far as I can tell it probably is healthier than normal chocolate, but not worth the huge premium over other high coacoa dark chocolates, and probably not as amazing and healthy as the Oxcai reps make out.
I read Is Oxcai A Scam? and the first and last couple of pages of Xocai - healthy chocolate or just another MLM scam. Listening to the radio broadcast, what I found interesting was when Moley asked the rep why it wasn't available to buy in shops, the rep just said that the product creator had already made a healthy chocolate before, and sold it in shops in the US and it was a great success with $383,000,000 in sales (something like that anyway). She said the creator wanted to create a really healthy high anti-oxidant chocolate, and no process existed so they had to develop it themselves and got a patent on it. And because the chocolate is cold pressed you don't loose all the goodness from the coacoa like you do with traditional chocolate, which is heated.
So she didn't answer the question at all, just tried to sell the product, kind of like how no Oxcai reps would answer the questions in the thread at 4networking about Oxcai's patent or independent trials showing Oxcai's healthy benefits.
After that I edited some photos.
After dinner I tried to rip my Tetris CDS, which arrived today. First of it made the CD drive go really loud and vibratey, so I had to restart my PC as the CD drive wouldn't eject. After that Exact Audio Copy (EAC) would just quit when I tried to extract the CD. I downloaded the latest version but still had the same problem. So I loaded up my IE6 virtual machine and downloaded EAC on that. I couldn't be bothered getting LAME set up with the best settings, so I just ripped the CD to FLAC and then copied it over to My Music.
Then I watched Lost with Mac and Ben and The Office (US) with Mac. After that I sorted some photos, checked my email and the Luminous Landscape.
The weather today was overcast all day except from about 5.30pm-6.00pm it was sunny. In the morning it was a bit foggy as well.
Food
Breakfast: Pink grapefruit marmalade toast sandwich; cup o' tea.
Lunch: Mature cheddar cheese with crunchy salad sandwich; 2x small clementines; slice of chocolate swiss roll; breakaway; cup o' tea.
Dinner: 2x sausage rolls; mashed potato; baked beans. Pudding was Jamaica Ginger cake with golden syrup and custard. Coffee.
Supper: Crinckle crunch; choc chip cookie; coffee.
Wednesday, 1 April 2009
Finished MT-24EX diffusion testing now I think
This morning I checked my email and kept going in the garden in the hope of finding some flea beetles I could test my home-made bouncer diffuser for the MT-24EX twin flash. Unfortunately whenever I did see a flea beetle, it would promptly hide. I also did some work on my photo website. Eventually I did get a few flea beetle pics as well.
After lunch I went on Animal Crossing, and the animals did rubbish tricks since it's April Fools day. I tried to fool the Mayor by making him walk into a pitfall, but he just walked right over it! So I tried to do a another trick on him and get him run over by the bus, but that didn't work either :(
I took some photos of the macro setup I'd been testing, then took some more photos using my big home-made diffuser and one of the smaller new diffusers I'd made in the past few weeks. At 3x magnification, I set the flash power to 1/16 on the top flash with the large diffuser, and 1/64 power on the flash with the small diffuser to the left. The results were really great I thought.
The rest of the afternoon and part of the evening I was trying to figure out the SQL needed to get the siblings of a node using the Nested Set model. In the end I took the query for finding the Immediate Subordinates of a Node from the MySQL example, and added a subquery to the subquery that finds the parent of the currently selected node. Actually, the subquery I added doesn't find the immediate parent of the selected node, but rather the parent at a given depth level. So if the depth level given is wrong, then it will mess everything up. However, to find the depth in the query, I think I'd need to add another subquery. Maybe I will do that, but the query is pretty massive as it is, and my list of table aliases I have to lock is pretty large now as well.
In the evening as well as trying to figure out how to do that query, I also finished watching 'The Manchurian Candidate' with Mac. I thought it was too long and boring with lots of parts that weren't really important to the plot or character development. Not a bad film though, so I gave it 6/10.
The weather today was a mixture of sun and clouds with more sun that clouds most of the day, though it was clouded over completely about 4pm onwards.
Food
Breakfast: Pink grapefruit marmalade toast sandwich; cup o' tea.
Lunch: Ham with mustard and crunchy salad sandwich; banana; chocolate digestive bar; cup o' tea.
Dinner: Peas; Spicy chicken Deep pan pizza; potatoes. Pudding was Lemon pud with custard. Coffee; Sainsbury's caramel chocolate.
Supper: Scone with I didn't think it was butter; cup o' tea.
After lunch I went on Animal Crossing, and the animals did rubbish tricks since it's April Fools day. I tried to fool the Mayor by making him walk into a pitfall, but he just walked right over it! So I tried to do a another trick on him and get him run over by the bus, but that didn't work either :(
I took some photos of the macro setup I'd been testing, then took some more photos using my big home-made diffuser and one of the smaller new diffusers I'd made in the past few weeks. At 3x magnification, I set the flash power to 1/16 on the top flash with the large diffuser, and 1/64 power on the flash with the small diffuser to the left. The results were really great I thought.
The rest of the afternoon and part of the evening I was trying to figure out the SQL needed to get the siblings of a node using the Nested Set model. In the end I took the query for finding the Immediate Subordinates of a Node from the MySQL example, and added a subquery to the subquery that finds the parent of the currently selected node. Actually, the subquery I added doesn't find the immediate parent of the selected node, but rather the parent at a given depth level. So if the depth level given is wrong, then it will mess everything up. However, to find the depth in the query, I think I'd need to add another subquery. Maybe I will do that, but the query is pretty massive as it is, and my list of table aliases I have to lock is pretty large now as well.
In the evening as well as trying to figure out how to do that query, I also finished watching 'The Manchurian Candidate' with Mac. I thought it was too long and boring with lots of parts that weren't really important to the plot or character development. Not a bad film though, so I gave it 6/10.
The weather today was a mixture of sun and clouds with more sun that clouds most of the day, though it was clouded over completely about 4pm onwards.
Food
Breakfast: Pink grapefruit marmalade toast sandwich; cup o' tea.
Lunch: Ham with mustard and crunchy salad sandwich; banana; chocolate digestive bar; cup o' tea.
Dinner: Peas; Spicy chicken Deep pan pizza; potatoes. Pudding was Lemon pud with custard. Coffee; Sainsbury's caramel chocolate.
Supper: Scone with I didn't think it was butter; cup o' tea.
Subscribe to:
Posts (Atom)