NameSilo

JSP/database help

Spacemail by SpaceshipSpacemail by Spaceship
Watch

rayhab

Established Member
Impact
1
Hi, im trying to print the columns and rows from a database onto the jsp.
This code does that however, it will print the first column of each row into the last column and shift everything else into the column to the left.
Any ideas on what the problem could be?
<code>

<c:forEach var='item' items='${views2.rows}'>

<sql:query var="t1">
select * from ${item.tableName}
</sql:query>
<tr>
<c:forEach var='columnName' items='${t1.columnNames}'>
<td>
<font><b>--${columnName}--</b></font>
</td>

</c:forEach>
</tr>

<sql:query var="t2">
select * from ${item.tableName}
</sql:query>

<tr>
<c:forEach var='item2' items='${t2.rows}'>
<tr>
<c:forEach var='colval' items='${item2}'>
<td>${colval}</td>
</c:forEach>
</tr>
</c:forEach>
</tr>

.....
</code>
 
0
•••
The views expressed on this page by users and staff are their own, not those of NamePros.
AfternicAfternic
I don't use jsp but at a glance :

PHP:
<tr>
<c:forEach var='item2' items='${t2.rows}'>
<tr>
<c:forEach var='colval' items='${item2}'>
<td>${colval}</td>
</c:forEach>
</tr>
</c:forEach>
</tr>
you have a possibility of 2 <tr> i think
like
HTML:
<tr>
<tr>
<td>bla</td>
</tr>
</tr>
 
0
•••

We're social

Unstoppable Domains
Domain Recover
DomainEasy — Zero Commission
  • The sidebar remains visible by scrolling at a speed relative to the page’s height.
Back