Category Archives for Languages

How can i populate database tables from excel spreadsheet

Recently i got a excel spreadsheet document with a couple of thousand records which needed to be put into the database, I use MySQL so i had to prepare equal number of insert queries for the number of records in the excel … Continue reading

14. April 2013 by Anand
Categories: Databases, Languages, MySQL, SQL | Tags: , , , , , | Leave a comment

How do i use joins in sql ?

For those who think SQL joins are tough. Just go through this once and i bet you cannot forget it again. Courtesy:  C.L.Moffett, 2008

20. September 2012 by Anand
Categories: Databases, Languages, MySQL, SQL | Tags: , , , , , | Leave a comment

How do i detect if a browser window is closed or refreshed ?

This was the question I was asking myself when I  had to write a piece of code which needed to respond differently on browser close and on browser refresh. To my worst nightmare i found this issue seemed to trouble … Continue reading

16. August 2012 by Anand
Categories: All Browsers, Browser, Javascript, Languages | Tags: , , , , , | 37 comments

Google Chrome Popup Detection that actually works !

Hi, When i started looking out for javascript code that can detect Chrome’s (17.0) popup blocker, I tried lots of snippets. But most of them dint really work. So once i got it working, I thought it would be good … Continue reading

29. February 2012 by Anand
Categories: Browser, Chrome, Javascript, Languages | Tags: , , , , , | 8 comments