 | | | problems with esql logicsheet and insert | problems with esql logicsheet and insert 2004-01-03 - By Davide
Back
Hi; i have the following xsp to perform an insert into a table
<xsp:include>java.sql</xsp:include>
<xsp:logic>
java.util.Date  .html>java.util.Date java.util.Date .java.html>' border=0> now=new java.util.Date .html>java.util.Date java.util.Date .java.html>' border=0>();
</xsp:logic>
<esql:connection>
<esql:pool>mcnavigator</esql:pool>
<esql:execute-query>
<esql:query>Insert into comments (Comment_ID, User_ID, Comment_text,
Commented_URL, Comment_Date, Comment_browser) values (
'<xsp-session-fw:getxml context="authentication"
path="/authentication/ID"/>',
'<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"/>');
</esql:query>
</esql:execute-query>
</esql:connection>
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: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)
|
|
|