cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Suchandra Nag" <s...@chutneytech.com>
Subject Re: db dml & dcl operations in cocoon
Date Mon, 08 Apr 2002 15:12:12 GMT
Please un-subscribe this account... I have done so before but to no effect

----- Original Message -----
From: "Jerzy Kut" <jerzyk@rzeszow.tiger.com.pl>
To: <cocoon-users@xml.apache.org>
Sent: Monday, April 08, 2002 10:57 AM
Subject: db dml & dcl operations in cocoon


> Hi!
> I need to do INSERT, UPDATE and DELETE operations after submit my form.
> I have got defined my XSP logicsheet as my own taglib. It has appropriate
> operations using ESQL i.e.
>
>  <!--
>     - delete graduation data from database
>     - input parameters:
>     - * id - id of graduation (number)
>    -->
>  <xsl:template match="myapp:delete-graduation">
>
>   <graduations>
>
>    <esql:connection>
>     <esql:pool>mypool</esql:pool>
>     <esql:execute-query>
>      <esql:query>
>       delete from SALGRADE
>       where GRADE = <xsp-request:get-parameter name="id"/>
>      </esql:query>
>      <esql:error-results>
>       <graduation-error>
>        <esql:get-message/>
>       </graduation-error>
>      </esql:error-results>
>     </esql:execute-query>
>    </esql:connection>
>
>   </graduations>
>
>  </xsl:template>
>
> it is registered in cocoon.xconf.
> I want to use XSP generator to insert my data passed by URL and generate
> error (if any). In this case I need to generate response with error, but
> otherwise I want to make redirection to another pipe. How to get
> <graduation-error> tag from response?
> Is it good way to do what I need? Maybe it is simplest to do it by
Actions?
> But how to get DBConnection from my "mypool" pool?
>
> Help please.
>
> Regards
>
> Jerzy Kut
>
>
>
> ---------------------------------------------------------------------
> 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: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
>


---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message