0 Replies Latest reply on Oct 16, 2011 4:55 PM by 826025

    Null value for a column field when using jstl sql tags.

    826025
      I used jstl sql tags to perform a database operation but i get null value for a column field.
      And i got the field value when i used it with scriptlet. Whats wrong here?

      <sql:setDataSource var="db" driver="sun.jdbc.odbc.JdbcOdbcDriver" url="jdbc:odbc:db" user="root" password="1234" />
      <sql:query var="emp" dataSource="${db}">
      select desig from employee where emp_id=?
      <sql:param value="${param.id }"/>
      </sql:query>

      <c:forEach var="row" items="${emp.rows}">
      Your designation is : ${row.desig}
      </c:forEach>