RE: SQL RE: 2 (should be) easy questions

Richard Cunliffe Wed, 12 Mar 2003 09:17:42 -0800

Thorsten,

Ok, I got some results to come out, but as soon as add more to the XSL style sheet nothing appears from the database.

Is it possible for you to have a look at my style sheet, and see if there are any obvious mistakes?

Many Thanks,

Richard.

-----Original Message-----
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]
Sent: 12 March 2003 16:34
To: [EMAIL PROTECTED]
Subject: AW: SQL RE: 2 (should be) easy questions

Hello Richard,

ok, i am still a whee bit confused but I try to answer.

You don't need to declare it! If so the CDATA would be the best!

You are using <sql:...> that tells me that you need a <map:transform type="sql"/> in your sitemap!

Like that:

<map:match pattern="verkauf-cp">
<map:generate src=""> <map:transform type="sql"/>
<map:serialize type="xml"/>
</map:match>

is that right? ...and is it working?

King regards

Thorsten

-----Ursprüngliche Nachricht-----
Von: Richard Cunliffe [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 12. März 2003 17:07
An: [EMAIL PROTECTED]
Betreff: SQL RE: 2 (should be) easy questions

Thorsten,

The second question is about the SQL statement I have in my XML document. I am unsure how to declare it in my DTD.

Do you know if it is possible to define the SQL statement in my XML document in the DTD? I have everything defined, but I know that the SQL statement is defined wrongly. It is currently defined as data, so that means when a style sheet is applied, it only gives the SQL statement and not the results.

Can you help? I have attached my DTD and XML files.

Richard.

-----Original Message-----
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]
Sent: 12 March 2003 15:52
To: [EMAIL PROTECTED]
Subject: AW: 2 (should be) easy questions

Hello Richard,

to 1) yes you have to define the image in the sitemap (e.g. from my sitemap (will not work with your configuration)):


<map:pipeline>

<map:match pattern="img/**.gif">
  <map:read src="" mime-type="images/gif"/>
</map:match>

<map:match pattern="img/**.jpg">
  <map:read src="" mime-type="images/jpeg"/>
</map:match>
<map:match pattern="img/**.jpeg">
  <map:read src="" mime-type="images/jpeg"/>
</map:match>
</map:pipeline>

to 2) ??? don't understand the problem

King regards

Thorsten

-----Ursprüngliche Nachricht-----
Von: Richard Cunliffe [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 10. März 2003 18:49
An: [EMAIL PROTECTED]
Betreff: 2 (should be) easy questions

Hi,

I have two questions:

1.                  I’m not sure if this cocoon or my inability to do XSL, but I have my web page images in an images folder, under the root directory soundpool. Everything was looking good until I checked the site in netscape, when I found the images were not loading. I consequently checked on other on other computers, and they were not working there either. Do I need to included something in my sitemap to tell cocoon where the images are. If this is not the case, could someone please tell me how to get them to work. The rest of my XML is being parsed correctly. Below is an example in my style sheet referencing an image:

   <img src="C:\tomcat\webapps\cocoon\soundpool\images\uktop10.gif"/> - This is what XML Spy produced in its XSLT designer, I have also tried



   <img src="images\uktop10.gif"/> – this also doesn’t work

2.                  My next question is a DTD question

I have SQL statements in my XML code to query a MySQL database, and I now want to display the results, but how do I define this SQL query in my DTD?? I have attached a XML file.

Richard.

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
	xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
	xmlns:sql="http://apache.org/cocoon/SQL/2.0";>



<xsl:template match="/">

 <html>
<head/>
			<body>
			 <img src="/soundpool/images/backgroundpda.jpg"/>
			 <title>soundpool</title>
				<xsl:for-each select="/">
	
					<table border="0" width="99%">
						<xsl:if test="position()=1">
							<xsl:text disable-output-escaping="yes">&lt;tbody&gt;</xsl:text>
						</xsl:if>
						<tr>
							<td align="right">
								<xsl:for-each select="pda">
									<span style="color:#2B4E71; font-family:Verdana; font-size:8pt">
										<xsl:for-each select="title">
											<span style="color:#2B4E71; font-family:Verdana; font-size:8pt">
												<span style="color:#2B4E71; font-family:Verdana; font-size:8pt">
													<xsl:apply-templates/>
												</span>
											</span>
										</xsl:for-each>
									</span>
								</xsl:for-each>
							</td>
						</tr>
						<xsl:if test="position()=last()">
							<xsl:text disable-output-escaping="yes">&lt;/tbody&gt;</xsl:text>
						</xsl:if>
					</table>

					<table border="0" width="99%">
						<xsl:if test="position()=1">
							<xsl:text disable-output-escaping="yes">&lt;tbody&gt;</xsl:text>
						</xsl:if>
						<tr>
							<td align="center" width="33%">
								<a href="soundpool.html">
								<span style="color:#2B4E71; font-family:Verdana; font-size:8pt">home</span>
								</a>
							</td>
							<td align="center" width="33%">
								<a href="database.html">
								<span style="color:#2B4E71; font-family:Verdana; font-size:8pt">database</span>
								</a>
							</td>
							<td align="center" width="33%">
								<span style="color:#2B4E71; font-family:Verdana; font-size:8pt">contact us</span>
							</td>
						</tr>
						<xsl:if test="position()=last()">
							<xsl:text disable-output-escaping="yes">&lt;/tbody&gt;</xsl:text>
						</xsl:if>
					</table>
		  	
				  	
				  	<!-- MySQL Query -->
				  	
				<!-- <table>
						<tr>
							<td align="right">
								<xsl:for-each select="."/>
							</td>
						</tr>
						<xsl:if test="position()=last()">
							<xsl:text disable-output-escaping="yes">&lt;/tbody&gt;</xsl:text>
						</xsl:if>

					</table> -->
					
					<table>
						<tr>
							<th>
								<xsl:for-each select="query">
									<xsl:for-each select="execute-query">
										<xsl:apply-templates/>
									</xsl:for-each>
								</xsl:for-each>
							</th>
						</tr>
					</table>


		</xsl:for-each>
	</body>
</html>

</xsl:template>	

</xsl:stylesheet>

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: SQL RE: 2 (should be) easy questions

Reply via email to