How to forward localhost IP-Address to an Android Emulator

Each emulator instance provides a control console the you can connect to, to issue commands that are specific to that instance. You can use the redir console command to set up redirections as needed for an emulator instance.

First, determine the console port number for the target emulator instance. For example, the console port number for the first emulator instance launched is 5554. Next, connect to the console of the target emulator instance, specifying its console port number, as follows:

telnet localhost 5554

Example:

Assume that your environment is
A is you development machine
B is your first emulator instance, running on A

Set up the server on B, listening to 10.0.2.15:<serverPort>
On B's console, set up a redirection from A:localhost:<localPort> to B:10.0.2.15:<serverPort>

* 10.0.2.15 is the default Ip Address of the Emulator
** For Windows: All Commands must be written in "Windows Command Prompt"

How to use alias in the WHERE or GROUP BY clause

One workaround would be to use a derived table:

select *
from 
   (
   select a + b as aliased_column
   from table
   ) dtwhere dt.aliased_column = something.

Add Code Syntax Highlighter To your Blog

A very tutorial on how to add code Highlighter to your Blogger's account.

http://heisencoder.net/2009/01/adding-syntax-highlighting-to-blogger.html