|
Sorry, That was not the right way,
using <sql :parameter …> works better… sorry sorry <p:config xmlns:p="http://www.orbeon.com/oxf/pipeline" xmlns:sql="http://orbeon.org/oxf/xml/sql"> <p:param type="output" name="data"/>
<p:processor
uri="oxf/processor/request"> <p:input name="config"> <config> <include>/request/parameters</include> </config> </p:input> <p:output
name="data" id="request"/> </p:processor> <p:processor
uri="oxf/processor/sql"> <p:input name="data" href="#request" /> <p:input
name="config"> <sql:config> <results>
<sql:connection>
<sql:datasource>magiccv</sql:datasource> <sql:execute> <sql:query xmlns:sql="http://orbeon.org/oxf/xml/sql">
select * from <sql:parameter
type="oxf:literalString" replace="true"
select="/request/parameters/parameter[name='table']/value" /> </sql:query> <sql:results>
<sql:row-results> <result>
<sql:get-columns /> </result> </sql:row-results>
</sql:results> </sql:execute>
</sql:connection> </results>
</sql:config> </p:input> <p:output name="data" id="document"
/> </p:processor> <p:processor
uri="oxf/processor/xslt"
xmlns:p="http://www.orbeon.com/oxf/pipeline"> <p:input name="data" href="#document" /> <p:input name="config"> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/results"> <html> <table
border="1"> <tr> <xsl:for-each select="result[1]/*">
<td>
<xsl:value-of select="name()"
/>
</td> </xsl:for-each> </tr> <xsl:apply-templates select="result" /> </table> </html> </xsl:template> <xsl:template match="result"> <tr> <xsl:apply-templates /> </tr> </xsl:template> <xsl:template match="*[parent::result]"> <td> <xsl:value-of select="."
/> </td> </xsl:template> </xsl:stylesheet> </p:input> <p:output name="data" ref="data"
/> </p:processor> </p:config> |
_______________________________________________ oxf-users mailing list [EMAIL PROTECTED] http://mail.orbeon.com/mailman/listinfo/oxf-users
