cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Russell Castagnaro <russ...@synctank.com>
Subject Re: Connecting to MySQL...
Date Thu, 29 Jun 2000 19:25:17 GMT
Maybe you should try it without the semicolon at the end of the query.
-russell

"Roderick A. Carder-Russell" wrote:

> I'm attempting to connect to a MySQL database and extract information to
> be placed into my XML document.  I've put all of what I believe are the
> appropriate tags into the documents, including the XSL to reference and
> print out my data to a browser.  It does not seem to want to cooperate
> though.  What I end up seeing is a blank browser window.  I don't even get
> any error message.  I've included the the trimmed down markup below.  I'd
> be greatful if anyone could spot problems or give advice.
>
> ------THE XML DOCUMENT------
>
> <?xml version="1.0"?>
> <?xml-stylesheet href="mystyle.xsl" type="text/xsl"?>
> <?cocoon-process type="sql"?>
> <?cocoon-process type="xslt"?>
>
> <test>
>         <connection name="dbconnection">
>                 <driver>org.gjt.mm.mysql.Driver</driver>
>                 <dburl>jdbc:mysql://www.myserver.com/mydb</dburl>
>                 <username>myusername</username>
>                 <password>mypassword</password>
>         </connection>
>
>         <query connection="dbconnection">
>                 SELECT myfield FROM mytable ORDER BY myfield;
>         </query>
> </test>
>
> -------THE XSL DOCUMENT------
>
> <?xml version="1.0"?>
> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
> <xsl:template match="/">
> <xsl:processing-instruction name="cocoon-format">type="text/html"</xsl:processing-instruction>
>
> <xsl:for-each select="test">
>         <xsl:value-of select="myfield"/>
> </xsl:for-each>
>
> </xsl:template>
> </xsl:stylesheet>
>
> --------------
> Roderick A. Carder-Russell
> rodc@shore.net
> --------------
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org

--
Hope to see you at my presentation, "Making the Most of XML, XSL and Server-Side Processing"
at XML DevCon 2000, June 25-28, 2000.

Russell Castagnaro
Chief Mentor
SyncTank Solutions
http://www.synctank.com

Earth is the cradle of mankind; one does not remain in the cradle forever
-Tsiolkovsky



Mime
View raw message