Check out the sql tags that are a part of the Standard tag library implementation available in the jakarta taglibs project. You can use the column name to get the column value when iterating over the rows:
<sql:update var="newTable"> create table mytable ( nameid int primary key, name varchar(80) ) </sql:update> <sql:query var="resultSet"> SELECT * FROM mytable </sql:query> <%-- using the column name to access the value --%> <c:forEach var="row" items="${resultSet.rows}"> Name: <c:out value="${row.NAMEID}"/> Value: <c:out value="${row.NAME}"/> </c:forEach> Justy ----- Original Message ----- From: "Soefara Redzuan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 11, 2002 5:51 AM Subject: why is there no dbtags getField tag ? > Instead of writing getColumn, is there a more intuitive method that uses the > field name instead getColumn ? For example the current method is this > > <sql:statement id="stmt1" conn="conn1"> > <sql:query> select * from members </sql:query> > <sql:resultSet id="rset2"> > <sql:getColumn position="1"/> > <sql:getColumn position="2"/> > </sql:resultSet> > </sql:statement> > > Why is there not something like this instead > > <sql:statement id="stmt1" conn="conn1"> > <sql:query> select * from members </sql:query> > <sql:resultSet id="rset2"> > <sql:getField name="firstname" /> > <sql:getField name="lastname" /> > </sql:resultSet> > </sql:statement> > > Or does something like this exist ? > > Thank you, Soefara. > > _________________________________________________________________ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>