SQL RE: 2 (should be) easy questions

Richard Cunliffe Wed, 12 Mar 2003 08:05:45 -0800

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.

dtdxml.zip
Description: Zip compressed data

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

SQL RE: 2 (should be) easy questions

Reply via email to