Summary: | DBTags having problems with mySQL Year Field | ||
---|---|---|---|
Product: | Taglibs | Reporter: | Richard Howard <richard> |
Component: | Standard Taglib | Assignee: | Tomcat Developers Mailing List <dev> |
Status: | RESOLVED WORKSFORME | ||
Severity: | normal | ||
Priority: | P3 | ||
Version: | 1.0 | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Linux |
Description
Richard Howard
2003-11-26 22:26:07 UTC
I wrote a simple example to try to reproduce your problem, but it worked for me. Could you attach a war file with the simplest example that would reproduce your problem. The following works for me... --- <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %> <c:catch var="ex"> <sql:update> DROP TABLE FILMS </sql:update> </c:catch> <sql:update> CREATE TABLE FILMS ( ID int auto_increment primary key, NAME varchar(80), ZEYEAR year ) </sql:update> <sql:update> INSERT INTO FILMS VALUES (null, 'film1', 2002), (null, 'film2', 2003), (null, 'film3', 2004) </sql:update> <sql:query var="result"> SELECT * FROM FILMS </sql:query> <table> <c:forEach items="${result.rows}" var = "row"> <tr> <td><c:out value = "${row.ZEYEAR}"/></td> </tr> </c:forEach> </table> |