Helen, > 1. SQL result display problem. > I successfully retrieve the resultset using > > <c:forEach var="column" items="${row}"> > <td><c:out value="${column}"/></td> > </c:forEach> > > However, the following code retrieves blank values. I can see multiple empty > lines, which means the query is successful, but all the values are blank. > > <c:forEach var="row" items="${project.rows}"> > <tr> > > <td> <c:out value="${row.proj_name}"/> </td> > <td> <c:out value="${row.task_name}"/> </td> > <td> <c:out value="${row.task_status}"/> </td> > <td> <c:out value="${row.act_name}"/> </td> > <td> <c:out value="${row.activity_status}"/> </td> > </tr> > </c:forEach>
If I had to guess, I'd say that there's a mismatch between the column capitalization that your database is returning and the ones that you're using in your expressions (e.g., "proj_name" versus "PROJ_NAME"). JSTL is currently case-sensitive in this regard, although we're actively considering whether (and how) to make it case insensitive. One easy way to tell for sure if column-name mismatches are at the root of your problem is to use 'result.rowsByIndex' instead of 'result.rows' and then to access column numbers instead of names. > 2. fmt:message cannot properly display text > I am only using fmt:message tag, all the messages are displayed as > "???". If I type in a non-exist value as either key or message tag's > body content, it at least displays the original value. For example > > <fmt:message key="engineering_name" /> (engineering_name doesn't exist in > resource bundle) > displays: > ???engineering_name??? > > This seems to me indicate that fmt tag is able to locate the bundle > and key, but is not able to display it. Similar to what Jan said, this sounds just like the tag isn't finding your bundle. (As Jan said, the name for the parameter/attribute changed.) -- Shawn Bayern Author, "JSP Standard Tag Library" http://www.jstlbook.com (coming this summer from Manning Publications) -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>