Monthly Archives: November 2014

TSQL’s Equivalent to Create New Query Based on Previous Query Result

I have a table called PRICE with two columns, unitPrice and resellerId. From my application, I use the following code (pseudo) to query the unitPrice for a given reseller. Basically I use the unitPrice if the resellerId presents in the … Continue reading

Posted in Database | Tagged , | Leave a comment

How to Serialize Map in Apache CXF

When developing CXF based web services, did you ever get “org.apache.cxf.interceptor.Fault: Marshalling Error: java.util.Map is not known to this context” error message? This is caused by JAXB, the default databinding used by CXF, unable to marshal/unmarshal Java Maps. The common … Continue reading

Posted in Java, Programming | Tagged , , , , , , , | 1 Comment

Excel Macro: Use VBA to Copy Column Data Into Rows

In this blog, I will demonstrate how to copy data from a complicated Excel spreedsheet and paste it into another worksheet with a VBA macro. Problem Scenario Very often, you have a complicated worksheet and you want to flat the … Continue reading

Posted in Excel, Programming, Tool and Debug, VB | Tagged , , | Leave a comment