I'm trying to do the following :
<esql:query>
INSERT INTO foo(id,url,email,username,password)
VALUES (<esql:parameter>NEXTVAL('id_seq')
</esql:parameter>,'abcd','[EMAIL PROTECTED]','dfgdf','123');
</esql:query>
Error generated by C2 :
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate():java.lang.RuntimeException: Error executed
prepared statement: INSERT INTO foo(id,url,email,username,password) VALUES
(?,'abcd','[EMAIL PROTECTED]','dfgdf','123'); : java.sql.SQLException: ERROR: pg_atoi:
error in "NEXTVAL('id_seq')": can't parse "NEXTVAL('id_seq')"
id is my primary key and i would like to auto-increment it.
Any suggestion ?
---------------------------------------------------------------------
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]>
