column name values

[Eman Adenola]

I am stuck..and I have no idea why this is happening at all. In theory it should work..and I believe it would work for php..but here goes

<table id="tableResult">
                <c:forEach items="${accset.columnNames}" var="col">
                    <c:set var="colname" value="${col}" scope="page"/>
                    <tr>
                      
                        <td>
                            ${accset.rows[0].colname} <%--I tried ${accset.rows[0].col} but it didn't work either...a c:out doesn't even show any thing--%>
                        </td>
                    </tr>
                </c:forEach>

I am trying to display the contents of the record that is related to a column..but it isn't working..I don't get why...JSP is supposed to be dynamic?
It saves me time hard coding all the freaking columns...
Does anyone have any idea why it isn't working?
Thanks

[Eman Adenola]

oh...looking at that..i think i made a mistake..brb

Nope: it should work.because I am saying accset.rows[0].ID and so on...so why isn't it.. arrgh
It is valid code!

[Vijitha Kumara]

For what the "accset" refers to here?

[Eman Adenola]

Vijitha Kumara wrote:For what the "accset" refers to here?

accset is the resultset from the query.

 <sql:query var="accset" dataSource="${datasource}" scope="session">
            select * from Users where UserName=?
            <sql:param value="${sessionScope.uname}"/>
        </sql:query>
        

apparently I found that doing this

  <c:set var="colname" value="${accset.rows[0]}.${col}" scope="page"/>

returns crap that looks like this

{AddressLine1=Apt 5 Clyde Road, AddressLine2=Donnybrook, City=Dublin, FirstName=Joseph, LastLoginDate=19-04-2011, Mobile=876654456, NoBooksReserved=0, Password=kj7899, Surname=Crotty, Telephone=8887889, Username=joecrotty}.

But I have no idea how to format into a table..I still think the first way would have been easier IMHO...

[Bear Bibeault]

resultsets are not suitable for use on a JSP.

Copy any data to collections such as a List for passing to the JSP and close the resultset as soon as possible.