cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Richard Cunliffe" <>
Subject SQL RE: 2 (should be) easy questions
Date Wed, 12 Mar 2003 16:06:40 GMT


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.





-----Original Message-----
From: Scherler, Thorsten [] 
Sent: 12 March 2003 15:52
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)):

 <!-- =========================== Ressources
================================ -->
 <!-- images gif -->
 <map:match pattern="img/**.gif">
  <map:read src="resources/images/{1}.gif" mime-type="images/gif"/>
 <!-- images jpg -->
 <map:match pattern="img/**.jpg">
  <map:read src="resources/images/{1}.jpg" mime-type="images/jpeg"/>
 <map:match pattern="img/**.jpeg">
  <map:read src="resources/images/{1}.jpeg" mime-type="images/jpeg"/>


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

King regards



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





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


   <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.




View raw message