Why you don't try this:
<esql:query>insert into query_stack
(t_stamp,username,q_body,q_type) values (
NOW(),
<esql:parameter><xsp:expr>uname</xsp:expr></esql:parameter>,
<esql:parameter><xsp:expr>param</xsp:expr></esql:parameter>,
<esql:parameter><xsp:expr>Integer.parseInt(sql_type)</xsp:expr></esql:parame
ter>
)
</esql:query>
yours
Christoph Gaffga
[EMAIL PROTECTED]
From: "yuryx" <[EMAIL PROTECTED]>
> Is there any way to insert full datetime value into oracle database
> using the following syntax:
> <xsp:logic>
> java.util.Date today=new java.util.Date();
> </xsp:logic>
> ...
> <esql:query>insert into query_stack
> (t_stamp,username,q_body,q_type) values (
> <esql:parameter type="Date"
> ><xsp:expr>java.sql.Date(today.getTime())</xsp:expr></esql:parameter>,
> <esql:parameter><xsp:expr>uname</xsp:expr></esql:parameter>,
> <esql:parameter><xsp:expr>param</xsp:expr></esql:parameter>,
>
>
<esql:parameter><xsp:expr>Integer.parseInt(sql_type)</xsp:expr></esql:parame
ter>
> )
>
> </esql:query>
> I always get the result value with 'zero' time :( , and I need to be
> able to insert hh24:mi:ss values.
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
