Hi Philip,
I think you are supposed to have #value# instead of #exectime#. You can use a
paramname other
than "value" if it is passed in a hashmap were the key is "paramname" or a bean
where the
"paramname" is the field defined there.
Thanks
Prashanth.
--- Philip Chan <[EMAIL PROTECTED]> wrote:
> Hi
>
> I have this delete statement
>
> java.util.Date now = new Date();
> SqlMapClient client = null;
> Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");
> client = SqlMapClientBuilder.buildSqlMapClient(reader);
>
> client.delete("ActivityLog.PurgeDate", now);
>
> Inside sqlmap.xml
> <delete id="ActivityLog.PurgeDate" parameterClass="date">
> <![CDATA[
> delete from activitylog al where where al.exectime <= #exectime#
> ]]>
> </delete>
>
> The record never got deleted.
>
> I am using ibatis 2.0.x and oracle 9.
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
