michael-fraser.com
what interests me
00904. 00000 – invalid identifier
Sep 2nd
I have been writing some scripts in oracle and have just encountered and solved a niggly little problem. Syntax difference between SQL Server and Oracle threw me.
On performing this query, was receiving this error: 00904. 00000 - "%s: invalid identifier".
WITH tempTab AS
(
SELECT a,b,c,d,e, ROW_NUMBER() OVER (partition by a ORDER BY e) AS "RowNums"
FROM S1SSP_STU_SPK
ORDER BY aASC
)
SELECT * From tempTab WHERE RowNums = 1
Because the RowNums is a created column name, the referred RowNums outside of the WITH clause must also be referenced in the same manner i,e “RowNums”
Logical right? ;P
Health Benefits of Believing
Aug 12th
An interesting new study has been released linking faith in God to higher survival rates in patients who have had a transplant.
“The research found that 93.5 per cent of religious worshippers where still alive four years after an operation while only 79.5% of their non-religious counterparts survived.
The statistics suggest that the mortality rate for a liver transplant patient who does not believe in God is three time higher than for those who do – 20.5 per cent compared to 6.6 per cent.”
It will be interesting to see what the atheists think about this seeing they believe religion is a waste of time. Interestingly, wouldn’t these statistics of religion helping patients to survive longer fit into their theory of ‘Survival of the fittest?’ meaning that belief serves a purpose and these believers have a survival advantage over those that do not believe?
Flock Web-browser
Jan 24th
I have just downloaded and configured a new web browser called Flock. (http://www.flock.com/) It is actually pretty neat. Based on the mozilla engine, it aims to bring in all of your social networking sites into the one area.
You can access your email accounts like Gmail and Yahoo, access and post to Twitter and Facebook, post to your blog via a built in blog client (pretty basic) view rss feeds etc. I have been a default Internet Explorer user for many years, however the features in this browser and such that I think this will become my default web browser. I’m loving it!
I would love to know what you think.
Hello World! The search for a Word Press editor.
Jan 21st
The time has come to revive my blog, and what better way to do this than start from scratch. I have told myself that it is time to start taking internet marketing seriously and as such, I am looking at getting up to speed with all of the new social networking technologies and what impact they can have on ecommerce businesses.
So before I get too serious, I need to find a decent editor for word press, and what I mean by that is a word press editor that can be run from windows, is easy to use and has some administrative features so I do not have to log into word press.