I am using Java and XML to code a project and I'm facing a problem... I am using SQL to pull a list of cities... the data shows up like this:
Atlanta
Raleigh
New York
Denver
San Francisco
London
but I want it to look like this
Atlanta New York San Francisco
Raleigh Denver London
How can I do this without having to create a dummy table in SQL, since I did this but there are some cases where my query includes less Cities, for example
Atlanta New York
Raleigh Denver
and I face a problem since I cannot make the empty columns disappear... just in case, I'm building this with Websphere Portlet Factory
2007-03-09
03:09:15
·
1 answers
·
asked by
quiksilver_army
2