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: <[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]>
