Skip to main content

Posts

Showing posts from December, 2013

Time Management by Brian Tracy

Was lucky to have a chance to watch a video done by Brian Tracy on Time Management. It was great and thought to do a short note on that. Here is the note and the video. Here is the note I took by listening to it. Goals - what is it you want to accomplish ? personal/family goals business/financial goals self development goals Plans of Action - put it in writing Analysis - Make a list (make the list of day before evening - to do list) Set Priorities - what is relevant and irrelevant ? what is the most valuable use of my time ? Concentration - Learn how ! - work on single task at time until it is completed Deadlines and Rewards - positive logical consequences. Time Log - where is all your time going ? Procrastination - positive or negative - Do it now! Do it now! Do it now! - get the job done fast Delegate - delegate everything you can - Clarity Think what you want done - write it down Pick the right person to do it Crystal clear on what you want done and wh

Safari is randomly switching images on ios 5

Developed a Facebook app for mobiles and it was loading a lot of images through several AJAX requests. And was working fine on simulators tried and was given to Client for testing. But suddenly was receiving screenshots of the app that appears sooo wired. With the details of the versions and devise he was testing I just Googled regarding this and found it is an error or a bug or a mistake or something that happens on Safari on iOS 5. Best result found on this matter, http://tech.vg.no/2011/12/14/safari-on-ios-5-randomly-switches-images/ Successfully tested on latest iOS versions and also on few android devices and they were fine. My suggestion is please update your OS if you still got iOS 5.

Concat columns on GROUP BY in MySQL by Using GROUP_CONCAT

I was asked to give a report on the Invitations table as follows. What I wanted to give as the result is the invitee details per inviter. So simply I do not want to repeat the "inviter". Invitations invitee_name inviter invitee gayan          345         4654 kosala          345         7655 chamara          567         7653 nilanka          567         1236 So basic query for the demanding result is "SELECT * FROM Invitations GROUP BY inviter;"  But then what happens is some results are omitted. So I need to concat the "invitee" and "invitee_name" columns when grouping by 'inviter'. For this MySQL simply gives a function as “GROUP_CONCAT”. Details can be seen on http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat . So for this example what I have to do is SELECT GROUP_CONCAT(invitee_name SEPARATOR ' || ') AS inviteeName, inviter, GROUP_CONCAT(invitee SEPARAT