Martin Duffy wrote:
>
> <snip>
>
> Would it be possible to just put the information that is in the sqltest.xml
> file into the portletregistry.psml entry to get it to execute on the
> homepage?
>
> Portletregistry.psml entry:
>
> <entry type="ref" parent="Cocoon" name="dptest" application="true">
> <url>/content/dynamic/sql/sqltest.xml</url>
> <parameter name="stylesheet"
> value="/content/dynamic/sql/sqltest.xsl"/>
> <metainfo>
> <title>My SQL test</title>
> <description>Sample SQL test.</description>
> </metainfo>
> </entry>
>
This looks good to me...
> sqltest.xml
>
> <?xml version="1.0"?>
> <?xml-stylesheet href="/content/dynamic/sql/sqltest.xsl" type="text/xsl"?>
> <?cocoon-process type="sql"?>
>
> <root>
> <connectiondefs>
> <connection name="issues">
> <driver>sun.jdbc.odbc.JdbcOdbcDriver</driver>
> <dburl>jdbc:odbc:issues</dburl>
> <username>dba</username>
> <password>sql</password>
> </connection>
> </connectiondefs>
>
> <query connection="issues">
> select appl_id, appcategory_id, description from a_appcategory
> </query>
>
> </root>
>
Looks fine too.
If you want to use this in a PSML file, simply put:
<entry type="ref" parent="dptest" />
in one of the <portlets> element...
This will display the content of the portlet in the specified set.
--
Rapha�l Luta - [EMAIL PROTECTED]
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
