You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@lenya.apache.org by Frank Hamilton <ii...@hotmail.com> on 2009/07/28 11:36:28 UTC
SQL Transform
Hello,
I need to see the result of a query in xml. This consultation is carried out
through a sql transformer. This is my sitemaps:
<map:match pattern="fichasDestacadas-**.xml" >
<map:generate src="cocoon:/sqlFichas.xml"/>
<map:transform src="xslt/presentacionFichas.xsl">
<map:parameter name="prefix" value="{1}"/>
</map:transform>
<map:serialize type="xhtml"/>
</map:match>
</map:pipeline>
<map:pipeline>
<map:match pattern="sqlFichas.xml">
<map:generate src="fichasSql.xml"/>
<map:transform type="sql">
<map:parameter name="use-connection"
value="PinturexBDConnection" />
<map:parameter name="show-nr-of-rows" value="true"/>
<map:parameter name="clob-encoding" value="UTF-8"/>
<map:parameter name="uuid"
value="{page-envelope:document-uuid}"/>
<map:parameter name="language"
value="{page-envelope:document-language}"/>
</map:transform>
<map:serialize type="xhtml"/>
</map:match>
</map:pipeline>
I tried to get an <map:serialize type="xml"/> for a xml output but not as
shown in my browser. I use this path in my browser:
http://localhost:port/pub-id/area/sqlFichas.xml .
You can tell me how he could see the outcome of the query through xml in my
browser.
Thanks
--
View this message in context: http://www.nabble.com/SQL-Transform-tp24695844p24695844.html
Sent from the Lenya - Users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@lenya.apache.org
For additional commands, e-mail: user-help@lenya.apache.org
Re: SQL Transform
Posted by Frank Hamilton <ii...@hotmail.com>.
I also like to know if I can paint the query in the log or display.
Thanks, very much.
--
View this message in context: http://www.nabble.com/SQL-Transform-tp24695844p24696473.html
Sent from the Lenya - Users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@lenya.apache.org
For additional commands, e-mail: user-help@lenya.apache.org
Re: SQL Transform
Posted by Thorsten Scherler <th...@juntadeandalucia.es>.
On Tue, 2009-07-28 at 02:36 -0700, Frank Hamilton wrote:
> Hello,
>
>
> I need to see the result of a query in xml. This consultation is carried out
> through a sql transformer. This is my sitemaps:
>
> <map:match pattern="fichasDestacadas-**.xml" >
> <map:generate src="cocoon:/sqlFichas.xml"/>
> <map:transform src="xslt/presentacionFichas.xsl">
> <map:parameter name="prefix" value="{1}"/>
> </map:transform>
> <map:serialize type="xhtml"/>
> </map:match>
>
> </map:pipeline>
>
> <map:pipeline>
> <map:match pattern="sqlFichas.xml">
> <map:generate src="fichasSql.xml"/>
> <map:transform type="sql">
> <map:parameter name="use-connection"
> value="PinturexBDConnection" />
> <map:parameter name="show-nr-of-rows" value="true"/>
> <map:parameter name="clob-encoding" value="UTF-8"/>
> <map:parameter name="uuid"
> value="{page-envelope:document-uuid}"/>
> <map:parameter name="language"
> value="{page-envelope:document-language}"/>
> </map:transform>
> <map:serialize type="xhtml"/>
> </map:match>
> </map:pipeline>
>
>
> I tried to get an <map:serialize type="xml"/> for a xml output but not as
> shown in my browser. I use this path in my browser:
> http://localhost:port/pub-id/area/sqlFichas.xml .
>
>
> You can tell me how he could see the outcome of the query through xml in my
> browser.
For this kind of stuff I usually write a module till I have something
stable. Then I call
http://localhost:port/modules/myDebugModule/sqlFichas.xml
I do this mainly because modules are copyless and I can edit the
xsl/sitemap and see them directly.
HTH
salu2
--
Thorsten Scherler <thorsten.at.apache.org>
Open Source Java <consulting, training and solutions>
Sociedad Andaluza para el Desarrollo de la Sociedad
de la Información, S.A.U. (SADESI)
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@lenya.apache.org
For additional commands, e-mail: user-help@lenya.apache.org
Re: SQL Transform
Posted by Florent André <fl...@4sengines.com>.
Hi,
You can have a look to the paragraph 2 to this page :
http://wiki.apache.org/lenya/DebuggingTips.
You will not see the output in your browser, but the stream after you
tranformer will be write in a file on your FS.
HTH
++
On Tue, 28 Jul 2009 02:36:28 -0700 (PDT), Frank Hamilton
<ii...@hotmail.com> wrote:
> Hello,
>
>
> I need to see the result of a query in xml. This consultation is carried
> out
> through a sql transformer. This is my sitemaps:
>
> <map:match pattern="fichasDestacadas-**.xml" >
> <map:generate src="cocoon:/sqlFichas.xml"/>
> <map:transform src="xslt/presentacionFichas.xsl">
> <map:parameter name="prefix" value="{1}"/>
> </map:transform>
> <map:serialize type="xhtml"/>
> </map:match>
>
> </map:pipeline>
>
> <map:pipeline>
> <map:match pattern="sqlFichas.xml">
> <map:generate src="fichasSql.xml"/>
> <map:transform type="sql">
> <map:parameter name="use-connection"
> value="PinturexBDConnection" />
> <map:parameter name="show-nr-of-rows" value="true"/>
> <map:parameter name="clob-encoding" value="UTF-8"/>
> <map:parameter name="uuid"
> value="{page-envelope:document-uuid}"/>
> <map:parameter name="language"
> value="{page-envelope:document-language}"/>
> </map:transform>
> <map:serialize type="xhtml"/>
> </map:match>
> </map:pipeline>
>
>
> I tried to get an <map:serialize type="xml"/> for a xml output but not
as
> shown in my browser. I use this path in my browser:
> http://localhost:port/pub-id/area/sqlFichas.xml .
>
>
> You can tell me how he could see the outcome of the query through xml in
> my
> browser.
>
> Thanks
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@lenya.apache.org
For additional commands, e-mail: user-help@lenya.apache.org