cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Davide <>
Subject problems with esql logicsheet and insert
Date Sat, 03 Jan 2004 10:37:02 GMT
Hi; i have the following xsp to perform an insert into a table

		java.util.Date now=new java.util.Date();
			<esql:query>Insert into comments (Comment_ID, User_ID, Comment_text, 
Commented_URL, Comment_Date, Comment_browser) values (
				'<xsp-session-fw:getxml context="authentication" 
				'<xsp-request:get-parameter name="comment_text"/>',
				'<xsp-request:get-parameter name="link"/>',
				'<xsp:expr>new java.sql.Timestamp(now.getTime())</xsp:expr>',
				'<xsp-request:get-header name="user-agent"/>');

When i execute it, i get a Unhandled exception type SQLException, but if I 
simply copy the query into mysql it runs;
Is there something wrong?

Best Regards, Davide 

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

View raw message