AW: SQL and Stylesheets
hi richard, I had a quick look at the xsl and it seems to me you should be learning some XSL ;-) maybe go to http://www.w3schools.com and check out their XSL tutorial. they even use some kind of cd database in that tutorial. may be the right thing for you. to the xsl: the element was supposed to go into the , the s and other stuff belong to the body (w3schools also has an html tutorial and tag reference). I haven't yet worked with the sql transformer, only with the esql logicsheet (which is supposed to be quite similar); that sql:* stuff doesn't like quite right either. > -Ursprungliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Auftrag von Richard Cunliffe > Gesendet: Donnerstag, 13. Marz 2003 17:19 > An: [EMAIL PROTECTED] > Betreff: RE: SQL and Stylesheets > > > > > OK I have got it working!! > > > But its not coming out in the correct table format, e.g. > > > The result im getting is: > > ParachutesWhats The Story Morning Glory > Coldplay > Oasis > > > The result I want: > > Coldplay Parachutes > Oasis The Story Morning Glory > > > > > I have attached my xsl, what can anyone suggest? > > Thanks, > > Richard. > > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: SQL and Stylesheets
Richard Cunliffe wrote: Thorsten Ok, I when I looked at the book I thought I would take it back one step, for it to make more sense to me. Therefore I thought I would start off doing all the XPATHs together instead of separating it out and doing many more MATCHes. The disadvantage in doing so is that you can not really debug the code! :( ...and frankly speaking don't result in doing all the XPATHs together it is only one match! ...and still you have a define a "match" within the ! You want to apply a template that matches select="/document/sql:rowset/sql:row/sql:artistbandname" ...but no where in your code s a ...please read the eMail I have send you! If you look on page 171 of the 'Cocoon Building applications' we can the result that the SQL transformer comes out with, we don't normally see this. Therefore I think I was calling templates that exist(although temporarily). Can you check I'm right? You are wrong that is the whole point in it! You are not calling a template()! You want to apply a template ()! ...but that is xsl stuff ...what comes out of a sql transformer is xml stuff! Node that you can match later on! I have got the results to come out correctly by just copying the book, NO! Ok, last time! Try: call it! post the result! Otherwise neither you nor me know what is the real result of the transform! Or maybe there is NO result! ...by the way : your sitemap and your xsl file: soundpool You should NOT DO that! One time is enough! but as soon as I start adding things to the style sheet, things start to go wrong, that's why I thought I would set it up myself from start to gain a better understanding. If I am calling the correct templates, can you see why it displays my XML document 3 times? If I'm wrong :-( about the templates on page 171, then tell me, and I will try and work from there example a bit more. That is just AN example NOT what is coming out for you! Thanks Richard By the way I have included my sitemap! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: SQL and Stylesheets
OK I have got it working!! But its not coming out in the correct table format, e.g. The result im getting is: ParachutesWhats The Story Morning Glory Coldplay Oasis The result I want: Coldplay Parachutes Oasis The Story Morning Glory I have attached my xsl, what can anyone suggest? Thanks, Richard. http://www.w3.org/1999/XSL/Transform"; xmlns:sql="http://apache.org/cocoon/SQL/2.0";> Soundpool - Database c o - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: SQL and Stylesheets
Richard, If you are running cocoon from the command line then be aware that the Cocoon class will request the page three times: once to determine the mime type, once to get the outgoing links, and once to get the actual content. Faron. > -Original Message- > From: Richard Cunliffe [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 13, 2003 10:32 AM > To: [EMAIL PROTECTED] > Subject: RE: SQL and Stylesheets > > > > Thorsten > > Ok, I when I looked at the book I thought I would take it > back one step, > for it to make more sense to me. Therefore I thought I would start off > doing all the XPATHs together instead of separating it out and doing > many more MATCHes. > > If you look on page 171 of the 'Cocoon Building applications' > we can the > result that the SQL transformer comes out with, we don't normally see > this. Therefore I think I was calling templates that exist(although > temporarily). > > Can you check I'm right? > > I have got the results to come out correctly by just copying the book, > but as soon as I start adding things to the style sheet, > things start to > go wrong, that's why I thought I would set it up myself from start to > gain a better understanding. > > If I am calling the correct templates, can you see why it displays my > XML document 3 times? > > If I'm wrong :-( about the templates on page 171, then tell me, and I > will try and work from there example a bit more. > > > Thanks > > Richard > > By the way I have included my sitemap! > > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: SQL and Stylesheets
Thorsten Ok, I when I looked at the book I thought I would take it back one step, for it to make more sense to me. Therefore I thought I would start off doing all the XPATHs together instead of separating it out and doing many more MATCHes. If you look on page 171 of the 'Cocoon Building applications' we can the result that the SQL transformer comes out with, we don't normally see this. Therefore I think I was calling templates that exist(although temporarily). Can you check I'm right? I have got the results to come out correctly by just copying the book, but as soon as I start adding things to the style sheet, things start to go wrong, that's why I thought I would set it up myself from start to gain a better understanding. If I am calling the correct templates, can you see why it displays my XML document 3 times? If I'm wrong :-( about the templates on page 171, then tell me, and I will try and work from there example a bit more. Thanks Richard By the way I have included my sitemap! sitemap.xmap Description: Binary data - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: SQL and Stylesheets
Hi Richard. you are calling templates which are not there! The example from Cocoon: building XML applications - with some comments: sqlexample.xsl: http://www.w3.org/1999/XSL/Transform"; xmlns:sql="http://apache.org/cocoon/SQL/2.0";> test Besides that it would be nice to see your sitemap.xmap and the result of the sql transformation of the database.xml <-Do you remember: King regards Thorsten Richard Cunliffe wrote: Thorsten and Marco, After reading the “Cocoon: Building XML Applications” and O’Reilly “XSLT” I have written my own “tidy and simple” XSL style sheet J (instead of using XML Spy). It’s giving results, but its not right. I have included the style sheet, the XML document, and a picture of the results. I’m sure it’s nothing to serious. It may be something to do with X-Paths but I cant be sure. Thanks, Richard. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
SQL and Stylesheets
Thorsten and Marco, After reading the “Cocoon: Building XML Applications” and O’Reilly “XSLT” I have written my own “tidy and simple” XSL style sheet J (instead of using XML Spy). It’s giving results, but its not right. I have included the style sheet, the XML document, and a picture of the results. I’m sure it’s nothing to serious. It may be something to do with X-Paths but I cant be sure. Thanks, Richard. results.zip Description: Zip compressed data - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]