Archive for January, 2010
.Net 4.0 Client Profile
Jan 25th
.Net 4.0 introduces the concept of Client Profile. I came to know about it when I was adding references to my project file. Even though, I had added a few assemblies in the project reference, the compiler was complaining of not finding the namespaces in the references that I have added during compilation.
The project was a Windows Form Application. I opened up the Project Settings Page to see that the
Target Framework was .Net 4.0 Client Profile.
I changed it to .Net 4.0 Framework. Everything worked fine.
So to get past the error of missing namespaces, even though the assemblies having been added, check to make sure that the Target Framework is not in the Client Profile.
Pongal
Jan 15th
Today is the Pongal Day! A harvest festival celebrated in our state in India. I am here in US, but I did make the sweet pongal, “Sakarai Pongal”. I will be missing the sugarcane and the total annular eclipse happening tomorrow.
Here are some things that I remember from my childhood days.
It began with the Pongal shopping. I used to go with my sister and dad to the Main Bazaar, in my hometown, Neyveli. They would have given the Pongal “bonus” for my dad, and so did every family in Neyveli. So everyone would be busy getting the bonus amount drained. The usually calm town of Neyveli will have small shops on the roads, selling clothes, fancy items and greeting cards.
The greeting cards would not be Archies, but a post card sized, normal graphic depicting a pot of pongal and two sugarcanes. I used to buy and send it to my friends living in Neyveli. It was fun. Nowadays, we send emails. But I somehow feel that, the postcard had a personal touch. This is not me whining, I enjoy it even now.
It was a nice occasion to celebrate. 3 days of holidays. Wow! It meant going to your native places, visiting relation’s home, getting together, gossiping, cinemas.
Happy Pongal!
PS: If someone has the old post card, can you please send me one?
Converting Rows to Columns in SQL
Jan 5th
There was this table,
ORG_ID LEGACY_ORG_CODE ------ ------------------ 1001 8909 1001 12323 1002 80909 1002 78798 1002 09009
and the requirement was to get the concatenated legacy_org_code like
ORG_ID LEGACY_ORG_CODE ------ ------------------ 1001 8909, 12323 1002 80909, 78798, 09009
The solution to this is:
SELECT PL.ORG_ID, (SELECT LEGACY_ORG_CODE + ',' FROM SGT_ORG_PLAN ORGPL WHERE ORGPL.ORG_ID = PL.ORG_ID ORDER BY LEGACY_ORG_CODE FOR XML PATH('')) AS ORG_CODE FROM SGT_ORG_PLAN PL GROUP BY PL.ORG_ID
I was looking for simple answers on the web I came across this link, that helped me to get it done in a simple SQL statement. Recording it here for future reference. This technique is called Blackbox XML.
New Look : Arjuna Theme
Jan 1st
One among the new year resolution is done. And on the same new year’s day. My site now has a new look. I have been wanting to do this for more than a year now, and I never pushed myself to sit and do it. What better time to do it, than in the vacation. And so, here is the new look for the site. I have decided to call the new theme “Arjuna”.
Arjuna: means ‘white’, ‘clear’. It is a Sanskrit word, and the name of one of the Pandavas, in the Mahabharata.
This theme is a white theme, minimal, and subtle in expression. Being my first side project, I was a bit confused in choosing a name. I chose this because, it was somehow connected to the ancient literature of my own country.
Feel free to download, test and report any bugs that you encounter.
Uninstalling MySQL on Mac OS X
Jan 1st
Here are the steps to perform a clean un-install of MySQL from your Mac.
Execute the following commands at the Terminal
Uninstalling MySQL
Open /etc/hostconfig file in a text editor and remove the following line
MYSQLCOM=-YES-
That’s all.
