-Erik
Dung wrote:
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
_______________________________________________ oxf-users mailing list [EMAIL PROTECTED] http://mail.orbeon.com/mailman/listinfo/oxf-users
