Now I'm thorougly confused. I could've sworn this was working before (as I claimed in
my
first email to the group.
<fmt:parseDate value="${param.dob}" var="parsed_dob" pattern="dd-MM-yyyy" />
<sql:transaction>
<sql:update>
INSERT INTO resource_registry ( dob )
VALUES (? <sql:dateParam value="${parsed_dob}" type="date"/> )
</sql:update>
</sql:transaction>
This works perfectly fine when I put a date in the format specified in the parseDate
action. The JSP book I got (O'Reilly 3rd Ed) says the <sql:dateParam> action is
supposed
to set the value to an SQL NULL when a null value is provided to it. I keep getting an
Invalid Column Type SQL exception (not an Oracle error) back whenever I leave the date
field blank. Anyone know what's wrong? Thanks!
Keith
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
