cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gustavo Mejia <gme...@infotec.com.mx>
Subject Re: how can I redirect my Result ? Using fp tag
Date Tue, 26 Jun 2001 14:06:12 GMT
Hello !!

Anybody read my message ?? any idea ?? please, I need your help !!

I still trying but I don't get it !

Gustavo !


Gustavo Mejia wrote:

> Hi,
>
> I am still trying to save my XML to a file, I am using fp tags, here I
> am trying to get and to save the field empno from the employee table,
> I need just exactly the same thing that I got in my browser, but now
> in a file (including the tags that describe the information of the
> field), but it doesn't work,  please ! I need your help !!
>
> Here my code,
>
> thanks a lot and sorry for the trouble !
>
> Gustavo
>
> <?xml version="1.0"?>
>
> <?cocoon-process type="xsp"?>
> <xsp:page
>   xmlns:fp="http://apache.org/cocoon/XSP/FP/1.0"
>   xmlns:request="http://www.apache.org/1999/XSP/Request"
>   xmlns:xsp="http://www.apache.org/1999/XSP/Core"
>   xmlns:esql="http://apache.org/cocoon/SQL/v2"
> >
>
> <fp:resource id="external-item">
>  <fp:resource-file>resulta.xml</fp:resource-file>
>     <fp:resource-node>/</fp:resource-node>
>  <fp:default-mode>replace</fp:default-mode>
> </fp:resource>
> <page>
>
> <esql:connection>
>   <esql:driver>oracle.jdbc.driver.OracleDriver</esql:driver>
>   <esql:dburl>jdbc:oracle:thin:@204.153.24.233:1521:cta</esql:dburl>
>   <esql:username>user</esql:username>
>   <esql:password>password</esql:password>
>   <esql:execute-query>
>
>      <esql:query>
>          select * from employee   order by empno
>      </esql:query>
>
>     <esql:results>
>       <header>Prueba ESQL para el CTA: </header>
>       <esql:row-results>
>
>        <empleado>
>
>          <fp:write to="external-item" select="column/empno
> as="string">
>                <request:get-parameter name="empno"/>
>          </fp:write>
>
>          </empleado >
>       </esql:row-results>
>       <footer>Aqui puede ir un pie de pagina</footer>
>     </esql:results>
>   </esql:execute-query>
> </esql:connection>
>
> </page>
> </xsp:page>
>
> Gustavo Mejia wrote:
>
>> Hi, sorry for the troubles but I am here again !
>>
>> Could somebody tell how can I use FP tags in order to save my XML
>> resulted from query ?  Here my code.
>>
>> <?xml version="1.0"?>
>>
>> <?cocoon-process type="xsp"?>
>>
>> <xsp:page
>>   xmlns:fp="http://apache.org/cocoon/XSP/FP/1.0"
>>   xmlns:request="http://www.apache.org/1999/XSP/Request"
>>   xmlns:xsp="http://www.apache.org/1999/XSP/Core"
>>   xmlns:esql="http://apache.org/cocoon/SQL/v2"
>> >
>>
>> <page>
>>
>> <xsp:logic>
>>     Date now = new Date();
>> </xsp:logic>
>>
>> <esql:connection>
>>   <esql:driver>oracle.jdbc.driver.OracleDriver</esql:driver>
>>   <esql:dburl>jdbc:oracle:thin:@My_IP:1521:cta</esql:dburl>
>>   <esql:username>user</esql:username>
>>   <esql:password>password</esql:password>
>>   <esql:execute-query>
>>
>>      <esql:query>
>>          select * from employee
>>          where empno=<esql:parameter
>> type="string"><request:get-parameter
>> name="EMP_CLVE"/></esql:parameter>
>>          or sex=<esql:parameter type="string"><request:get-parameter
>> name="EMP_SEX"/></esql:parameter>
>>          or sex=<esql:parameter type="string"><request:get-parameter
>> name="EMP_SEX2"/></esql:parameter>
>>          or birtdate=TO_DATE(<esql:parameter
>> type="string"><request:get-parameter
>> name="EMP_BIR"/></esql:parameter>,'DD/MM/YYYY')
>>          order by empno
>>      </esql:query>
>>
>>     <esql:results>
>>       <header>Prueba ESQL para el CTA Fecha de hoy :
>> <xsp:expr>now</xsp:expr></header>
>>       <esql:row-results>
>>         <empleado>
>>           <empno><esql:get-int column="empno"/></empno>
>>           <fisrtname><esql:get-string
>> column="fisrtname"/></fisrtname>
>>           <lastname><esql:get-string column="lastname"/></lastname>
>>           <salary><esql:get-int column="salary"/></salary>
>>           <job><esql:get-string column="job"/></job>
>>           <sexo><esql:get-string column="sex"/></sexo>
>>           <fecha><esql:get-date column="birtdate"/></fecha>
>>           <phone><esql:get-string column="phoneno"/></phone>
>>           <esql:connection>
>>             <esql:driver>sun.jdbc.odbc.JdbcOdbcDriver</esql:driver>
>>             <esql:dburl>JDBC:ODBC:SQL</esql:dburl>
>>             <esql:username>user</esql:username>
>>             <esql:password>password</esql:password>
>>             <esql:execute-query>
>>               <esql:query>
>>                    select * from Departamento
>>                    where empno = <esql:parameter
>> type="int"><esql:get-int ancestor="1"
>> column="empno"/></esql:parameter>
>>               </esql:query>
>>               <esql:results>
>>                 <esql:row-results>
>>                   <depto><esql:get-int
>> column="Departamento"/></depto>
>>                 </esql:row-results>
>>               </esql:results>
>>               <esql:no-results>
>>                 <depto>No hay depto</depto>
>>               </esql:no-results>
>>             </esql:execute-query>
>>           </esql:connection>
>>          </empleado >
>>       </esql:row-results>
>>       <footer>Aqui puede ir un pie de pagina</footer>
>>     </esql:results>
>>   </esql:execute-query>
>> </esql:connection>
>>
>> </page>
>>
>> </xsp:page>
>>
>>
>> Thanks a lot !
>>
>> Gustavo
>>
>>
>>
>> Gustavo Mejia wrote:
>>
>> > And, also, how can I save this results into an specific file
>> > automataclly ??
>> >
>> > Any Idea.. ?? I really appreciate all your help !!!
>> >
>> > Gustavo
>> >
>> > Gustavo Mejia wrote:
>> >
>> > > Hi !
>> > >
>> > > I am here again !
>> > >
>> > > I have a question, I have a very small application that makes a
>> > query to
>> > > my database, when I make the request I got the result in other
>> > XML
>> > > document but in my same page (well y the same browser) the
>> > question is,
>> > > how can I redirect the results, in order that this results appear
>> > in the
>> > > URL that I define, is it posiible, ?? how can I do that ?
>> > >
>> > > Please !! help me !!!
>> > >
>> > > Thanks a lot !!!
>> > > Gustavo
>> > >
>> > >
>> > ---------------------------------------------------------------------
>> >
>> > > 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