cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From S├ębastien Lefebvre <>
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


>Hi All,
>Can somebody tell me the correct way to encode the names of SQL functions in
>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:
>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. <>

To unsubscribe, e-mail: <>
For additional commands, e-mail: <>

View raw message