Nope, that didn't work. I don't see the identifiers being used anywhere in the Oracle
book I have. It didn't throw an error or anything, just did the same thing. Thanks for
the suggestion, though!
I did notice that I do have formated dates returning in another document, but the
forEach is using the rowsByIndex instead. The below outputs the TO_CHAR() formatted
date
exactly as I want it. Anyone know why the Indexed list returns the formated date, but
not the SortedMap?
<c:forEach items="${complete_list.rowsByIndex}" var="row">
<tr>
<c:forEach items="${row}" var="column">
<td>
<c:if test="${empty column}"> </c:if>
${column}
</td>
</c:forEach>
</tr>
</c:forEach>
Keith
---------- Original Message -----------
From: Hassan Schroeder <[EMAIL PROTECTED]>
To: Tag Libraries Users List <[EMAIL PROTECTED]>
Sent: Tue, 30 Mar 2004 13:57:17 -0800
Subject: Re: Formatted date not returning
> Keith wrote:
> > I'm trying to return a formatted date from an Oracle database. I format the date
> > in
the
> > query itself using the TO_CHAR() funtion. The problem is, when I use the TO_CHAR()
> > function, JSP is acting like nothing is returned. If I take the function out and
just
> > select the column as normal, it outputs but with the full TimeStamp (which I don't
want).
>
> I don't know Oracle, but if this was MySQL I'd say you need to
> assign an identifier to your returned result, something like
>
> > <sql:query var="resource_list">
> > SELECT
> > TO_CHAR(dob, 'DD-MON-YYYY')
> TO_CHAR(dob, 'DD-MON-YYY') AS thisDOB
> > FROM ccevs_resource_registry
> > </sql:query>
>
> ..and then call it as
>
> > <c:forEach items="${resource_list.rows}" var="resource_row">
> > <c:out value="${resource_row.dob}" />
> <c:out value="${resource_row.thisDOB}" />
>
> Untested, but FWIW!
> --
> Hassan Schroeder ----------------------------- [EMAIL PROTECTED]
> Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com
>
> dream. code.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
------- End of Original Message -------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
