Please be sure to use UBB code tags when posting code to the forums. Unformatted code is extremely hard to read and many people that might be able to help you will just move along to posts that are easier to read. Please read this for more information.
You can go back and change your post to add code tags by clicking the .
Paddu, First of all, note that it is considered extremely poor practice to put Java code in a JSP - especially JDBC code.
I can think of two possible approaches here. 1) Do the query as you are doing and create a Java data structure to represent what you want to output. 2) Write a query to generate the following and use a new entry in the first column to drive the header. solutions - web solutions - development products - softies etc