insert statement

[kiran vuppla <ki...@yahoo.com>]

�
Hi,
� I am having a insert statement and in which I am trying to insert values that I recieve from <selectKey> result. But I see that it is not inserting the value. Please let me know if it is correct way to do it?
�
In the below It is inserting null values for "#date#" which I get from <selectKey> statement.
�
<insert id="insertValues" parameterClass="Session">
<selectKey resultClass="java.sql.Date" type="pre" �keyProperty="date">
� select sysdate from dual
</selectKey>
�insert into SessionTbl (name, date, address, city, zip) values (#name#, #date#, #address#, #city#, #zip#)
</insert>
�
Thanks
KV