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

[Scherler, Thorsten]

I had a glance at your code, do you use the SPY as well to show the result?   I guess not! I am using the SPY as well.   Ok, correct me if I am wrong! I aspect your pipeline looks like that (because I guess you are using cocoon to transform): <map:pipeline>  <map:match pattern="database">   <map:generate src=""/>   <map:transform type="sql"/>   <map:transform src=""/>   <map:serialize/>  </map:match> </map:pipeline>   Is that right? If not -> it should look like that!   Explanation: <map:pipeline>  <map:match pattern="database">   1) <map:generate src=""/>   2)  <map:transform type="sql"/>   3) <map:transform src=""/>   <map:serialize/>  </map:match> </map:pipeline>   1) take the database.xml 2) excecute the SQL Statement <- that will produce XML 3) your transformation. BASED on everything before!   Try the following: <map:pipeline>  <map:match pattern="database">    <map:generate src=""/>    <map:transform type="sql"/>   <!-- <map:transform src=""/>-->   <map:serialize/>  </map:match> </map:pipeline>   then you see what you have to transform! See the source code (browser right click) and copy it to the Spy. from there you can copy the XPath. ...and then you *just* have to go on!   Hope that helps! Thorsten -----Ursprüngliche Nachricht----- Von: Richard Cunliffe [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 12. März 2003 18:47 An: [EMAIL PROTECTED] Betreff: RE: SQL RE: 2 (should be) easy questions Thorsten,   Ok the following statement is trying to display the results of the query from the MySQL database in a table, I don’t know if this is right.   What are you trying to do with, anyway: <xsl:for-each select="query">  <xsl:for-each select="execute-query">   <xsl:apply-templates/>  </xsl:for-each> </xsl:for-each>     The code looks complicated, because I am using XML Spy designer which allows you to put together your style sheet visually, with the aid of the DTD. The code above was the XML Spy’s way of trying to represent it from the DTD.   I have attached my xml, xsl, and dtd for you to have a look at to get a better understanding.   Many thanks,   Richard.