cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From S├ębastien Lefebvre <slefeb...@i2m.fr>
Subject Re: C2: ESQL how to encode NOW() function
Date Thu, 30 Aug 2001 10:29:59 GMT
My XSP pages work fine with the following stynax (I also use MySQL)

<esql:query>INSERT INTO TOTO VALUES ('','Hello',now())</esql:query>
You don't need the <esql:parameter> tag

S├ębastien

>Hi All,
>
>Can somebody tell me the correct way to encode the names of SQL functions in
>queries?
>
>I'm trying to set a DATETIME column to the current time by passing the
>function NOW() but the value is always ends up set to null.
>
>I've tried:
>
><esql:parameter>NOW()</esql:parameter>
><esql:parameter>"NOW()"</esql:parameter>
><esql:parameter><xsp:expr>"NOW()"</xsp:expr></esql:parameter>
>
>The insert statement works fine when I use the MySQL client.
>
>Any ideas?
>
>--
>



---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message