.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.

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?

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.

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.

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.