Perhaps you could try this:
<sql:update>
INSERT INTO myTable VALUES ( ? )
<fmt:parseDate value="${param.time}" var="myTime" type="both" />
<sql:dateParam value="${myTime}" />
</sql:update>You might have to give parseDate a pattern or dateStyle/timeStyle to parse correctly. Apparently the sql:dateParam is supposed to be used for DATE, TIME or TIMESTAMP columns.
fmt:parseDate will check for null and empty values and remove myTime from scope. I hope that means myTime will be null when param.time is an empty string.
-- Jason Lea
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
