Try using:
<esql:error-results>
<esql:get-message/>
</esql:error-results>
DR
At 05:42 PM 12/26/01 +0100, you wrote:
>Hello everybody,
>
>I have the following problem and for me it is hard to tell where the reasons are:
>
>I am trying to send an insert query to mySQL from an XSP-Page processed by
>Cocoon 2.
>
>If successful the resultpage shall yield some hopebringing comment, for
>example which values have been inserted.
>
>If the update fails (because of a SQLException) I need to tell it to the user.
>
>Therefore I have tried to use the <esql:results> and <esql:no-results> tags
>from the esql-taglib (this once worked fine with Cocoon 1 and Oracle 8). But
>with mySQL and Cocoon 2 it just won't work. Either I get always only success
>messages even if the query fails, or no text at all.
>
>Has anybody experiences with this or knows an answer that could help?
>
>Thanks,
>Uwe Stelzer
>
>
>Here is the source of my XSP page:
>
>--------------------------------------------------------------------------------------
>
><?xml version="1.0" encoding="UTF-8"?>
>
><xsp:page
> language="java"
> xmlns:xsp="http://apache.org/xsp";
> xmlns:esql="http://apache.org/cocoon/SQL/v2";
> xmlns:request="http://www.apache.org/1999/XSP/Request";
> xmlns:util="http://www.apache.org/1999/XSP/Util";
> >
>
><xsp:structure>
> <xsp:include>java.lang.*</xsp:include>
></xsp:structure>
>
><page>
>
> <xsp:logic>
> String something = request.getParameterValues("something")[0];
> //... maybe some more variables
> </xsp:logic>
>
><esql:connection>
> <esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
> <esql:dburl>jdbc:mysql://localhost:3306/myDatabase?user=myUser</esql:dburl>
>
> <esql:execute-query>
> <esql:query>
> insert into StudentTable (something)
> VALUES ('<xsp:expr>something</xsp:expr>')
> </esql:query>
>
> <esql:results>
> <esql:update-results>
> <success>
> <something>
> <xsp:expr>something</xsp:expr>
> </something>
> </success>
> </esql:update-results>
> </esql:results>
>
> <esql:no-results>
> <fail>
> <something>
> Oooops, database update query failed!
> </something>
> </fail>
> </esql:no-results>
>
> </esql:execute-query>
>
></esql:connection>
>
></page>
></xsp:page>
>
>--------------------------------------------------------------------------------------
>
>
>
>---------------------------------------------------------------------
>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]>
---------------------------------------------------------------------
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]>
