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?
--
Chris Newland
Software Research Engineer
Emorphia Ltd
Registered in England. 4133002
Mill House, Station Approach, Harlow Mill, Harlow, Essex, CM20 2EL, UK
Email: [EMAIL PROTECTED]
Tel: +44 (0)1279 450100
Fax: +44 (0)1279 450102
Check out FIPA-OS at http://fipa-os.sourceforge.net/
This message may contain information proprietary to Emorphia so any
unauthorised disclosure, copying or distribution of its contents is strictly
prohibited.
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
