Re: how can I redirect my Result ? Using fp tag
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/') 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
how can I redirect my Result ?
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]
how can I redirect my Result ?
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]
how can I redirect my Result ? Using fp tag
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/') 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]>