intern

Often we need MINUS operator as defined by the SQL definitions i.e you have two sets P and Q and you want P-Q which gives all the elements in P that are not in Q. But unfortunately, MYSQL does not have any operator for such an operation (yeah, I had the same reaction when I heard this!!). So here is a way how you can implement it in MYSQL. For simplicity let us consider we have two tables P and Q (we can also have views, joins, etc instead of the tables here) which have atleast one column in common (say id, which usually will be the primary key) and we want to evaluate P - Q which removes all those rows from P whose id is present in Q....

Until sometime back, I was unaware of how I could get the value of an auto-incremented field after an Insert Statement. But recently I needed it for two of my projects simultaneously, so I explored the possibilities. As one of my project is in Java and other is in PHP, we will go through both of them. So, here is the problem. In general, the PRIMARY KEY field is the AUTO_INCREMENT field. Now wen you insert a row, a new key is generated and you can’t get it through usual way as this row can be accessed only using the primary key. So here is how it can be done:

Recently while working for my project, I came across this situation when I had a 2-D array and I needed to sort it twice on 2 of its columns. Consider the following 2D array: [cc lang=“java”] String[][] testString = new String[][] { {“1”, “2”, “6”}, {“4”, “5”, “3”} }; [/cc] Sorting the above 2D array on zero column will give [cc lang=“java”] { {“1”, “2”, “6”}, {“4”, “5”, “3”} } [/cc] whereas sorting it on second column will give [cc lang=“java”] { {“4”, “5”, “3”}, {“1”, “2”, “6”} } [/cc] I did not want to do the most common as well as tedious thing, i.e. write my own sorting function like this: [cc lang=“java”] public void myOwnSort(String [][] exampleArray) { //code for sorting the array according to my wish. } [/cc] I wanted to avoid this for 2 resons: I would have to write the code for it ( lazy me!!). Secondly, I can possibly never match the efficiency provided by the sorting functions of java.util.Arrays

Feeds Image Grabber (FIG) was released on 3rd March 2010, to support the Feeds module. Introduction FeedAPI Imagegrabber is a add-on module for FeedAPI. It consists of a parser which visits the original URL of a new feed item, and retrieves the main image from the post. Once the main image has been retrieved, it is then converted into a thumbnail using the ImageCache module, and stored in the node created by FeedAPI, inside a CCK field. The purpose of FeedAPI Imagegrabber is to make the feed more informative as well as interesting for the user. As, we all know that “comics are much better than novels”, this module appends the feed-item with an appropriate image from its content URL. The goal of the module is to mimic the thumbnail display of websites such as digg.com. This goal is acheived by using FeedAPI to turn RSS feed-items into nodes, and then using FeedAPI Imagegrabber to append these nodes with an appropriate image from the feed-item’s webpage.

Note: The procedure given happened to me, I do not guarantee you the same, may be I was lucky or you will be. I leave the details of the trip (tiring but exciting) for my next post, and will try to outline the procedure to get the Schengen Student Visa for Internship from German Consulate at Kolkata. I specifically mentioned Kolkata because my friends faced quite a lot of problems at the Delhi Embassy. So you start with your documents, here is the list:

[caption id=“attachment_46” align=“aligncenter” width=“300” caption=“Kicked Away”] [/caption] Recently, my friend Anurag Nilesh got an intern in Switzerland. As I am going to Germany for the internship during summer, I thought of visiting him and shared my thoughts with him. I was perplexed with his following reaction: Me: yaar, main tuzhse milne switzerland zaroor aaunga.(I will definitely come to meet you.) nilesh: yaar lekin tu rahega kahan, wahan hotels badey mahangey hai!...