Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 52228 invoked by uid 500); 12 Mar 2003 16:06:55 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 52211 invoked from network); 12 Mar 2003 16:06:54 -0000 Received: from carbon.btinternet.com (194.73.73.92) by daedalus.apache.org with SMTP; 12 Mar 2003 16:06:54 -0000 Received: from host217-34-69-16.in-addr.btopenworld.com ([217.34.69.16] helo=richard) by carbon.btinternet.com with esmtp (Exim 3.22 #23) id 18t8kj-0001AA-00 for cocoon-users@xml.apache.org; Wed, 12 Mar 2003 16:06:49 +0000 From: "Richard Cunliffe" To: Subject: SQL RE: 2 (should be) easy questions Date: Wed, 12 Mar 2003 16:06:40 -0000 Message-ID: <001901c2e8b1$614e92f0$152ca8c0@richard> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_001A_01C2E8B1.61501990" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 In-Reply-To: <3671ACD9D9D5C648A6181F8048DC9A5D7C6D2C@srvde016.weidmueller.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N ------=_NextPart_000_001A_01C2E8B1.61501990 Content-Type: multipart/alternative; boundary="----=_NextPart_001_001B_01C2E8B1.61501990" ------=_NextPart_001_001B_01C2E8B1.61501990 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thorsten, =20 The second question is about the SQL statement I have in my XML document. I am unsure how to declare it in my DTD. =20 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. =20 Can you help? I have attached my DTD and XML files. =20 Richard. =20 =20 -----Original Message----- From: Scherler, Thorsten [mailto:Thorsten.Scherler@weidmueller.de]=20 Sent: 12 March 2003 15:52 To: cocoon-users@xml.apache.org Subject: AW: 2 (should be) easy questions =20 Hello Richard, =20 to 1) yes you have to define the image in the sitemap (e.g. from my sitemap (will not work with your configuration)): =20 to 2) ??? don't understand the problem=20 King regards Thorsten =20 -----Urspr=FCngliche Nachricht----- Von: Richard Cunliffe [mailto:richard@cunliffe.net] Gesendet: Montag, 10. M=E4rz 2003 18:49 An: cocoon-users@xml.apache.org Betreff: 2 (should be) easy questions =20 =20 Hi, =20 I have two questions: =20 1. I=92m 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: =20 = - This is what XML Spy produced in its XSLT designer, I have also tried =20 =96 this also doesn=92t work =20 =20 =20 2. My next question is a DTD question =20 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. =20 =20 Richard. ------=_NextPart_001_001B_01C2E8B1.61501990 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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:Thorsten.Scherler@weidmueller.de]
Sent: 12 March 2003 = 15:52
To: = cocoon-users@xml.apache.org
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)):

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

 

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


King regards

Thorsten

 

 -----Urspr=FCngliche Nachricht-----
Von: Richard Cunliffe = [mailto:richard@cunliffe.net]
Gesendet: Montag, 10. = M=E4rz 2003 18:49
An: = cocoon-users@xml.apache.org
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=3D"= C:\tomcat\webapps\cocoon\soundpool\images\uktop10.gif"/> - This is what XML Spy produced in its XSLT designer, I have also = tried

         &= nbsp;  

   <img = src=3D"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.

------=_NextPart_001_001B_01C2E8B1.61501990-- ------=_NextPart_000_001A_01C2E8B1.61501990 Content-Type: application/x-zip-compressed; name="dtdxml.zip" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="dtdxml.zip" UEsDBBQAAAAIAP1+bC4nqiRz9QAAAOsBAAAMAAAAZGF0YWJhc2UuZHRkdZDdTsIwFMfvTXyH47wZ SY+ZekMMSBDnjUMIbA8w24M0Ke3oWoW3t5lbIl83Tfr/+J2cMxjtNgq+ydbS6GF0f5dEQJobIfXX MCryN+xHo+frq8ENIsytEZ6TgM89LCRfl1bAxGslVytikMmAqYxRDIp3QMjK2oGvROlCI+njtLR8 jQ9J8giIHXIxm+WQZuk0/cg7ufsKw/2GtIPYSafChK0nu2cQkOHhDH7KqteBlsULtsXlMajpQVxv 1RPtiHtH2Ei9g9SJ/dfwNSE3WhN34USsiV1oH0Yhvp1PXsf5+DTY4s/6za4XvLB5e4wjnZ+Vw33+ 6b9QSwMEFAAAAAgA5XxsLu0jkUyFAQAAxAIAAAwAAABkYXRhYmFzZS54bWxtklFPwyAUhZ9r4n+4 8ixj6osu3cxsa2Ls7Fw7dY8McG3SQS1U57+X0dV0xoQHuJzzcTng3+62JXyKWhdKjtHFYIhASKZ4 ITdjtMzu8TUCbajktFRSjJFU6HZyeuKfYQzzWvGGCQ7rb1gULKc1h6CRZfH+Ls4hLiy2Uqo8h+Uj YIipNtBUnBrrGN7gGa1Zji+HwyvAuEOGWQhxEkyzh+SpK4dJkK3mEXDFmq2QBtJVmkUzQBZF11SL ATccdYS3WQx3Sbg6uDuTnZ+eeJ5vClOKickFdG6ftDW73Q6HSZ9jeF5GiwPH8/VHORI7wRoj8Ecj 6m+wyUk9svUxyo2pRoTQirJcDFS9IUwxpSSxGHJpQ524w/cM53VLL43iKMiA1qbQZm0zlnRrg9sI KWpabhtdMNca3C+SWU/mWOQI1i6P+nM37q4zD6fwEi3S31g9377EpBeJU7T/oJeITw6ylhJ0kI7B jhDB/wT2C3idzv+28UWrPmOv0KqRfP9zjjAHoRs+6b3rD1BLAQIUABQAAAAIAP1+bC4nqiRz9QAA AOsBAAAMAAAAAAAAAAEAIAC2gQAAAABkYXRhYmFzZS5kdGRQSwECFAAUAAAACADlfGwu7SORTIUB AADEAgAADAAAAAAAAAABACAAtoEfAQAAZGF0YWJhc2UueG1sUEsFBgAAAAACAAIAdAAAAM4CAAAA AA== ------=_NextPart_000_001A_01C2E8B1.61501990 Content-Type: text/plain; charset=us-ascii --------------------------------------------------------------------- To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org For additional commands, e-mail: cocoon-users-help@xml.apache.org ------=_NextPart_000_001A_01C2E8B1.61501990--