including a static XML file in the return from my sql call?

2003-06-30 Thread Paul Tomsic
I'm trying to import a static XML file into the results of my SQL call. Here's my sitemap.xmap block: and inside render-logic5

calling a custom method in a bean?

2003-06-17 Thread Paul Tomsic
Is it possible to alter the pipeline of cocoon so that we're calling a custom javabean that would generate the XML for the transform? (or at least call our own method from our bean?) More specifically, one of our reports needs column headers that have the date(s) of fiscal years on them. This inf

Re: escape "SUM" function from within sql:query in scheme.xml??

2003-06-16 Thread Paul Tomsic
would be using cocoon? >SUM() is not an XSLT/XPath function. Furthermore you wrote it as text, >not as expression, so this can't be the reason for your problem. >Joerg >Paul Tomsic wrote: > Is there a way to escape the SQL function SUM() > from within the element in

escape "SUM" function from within sql:query in scheme.xml??

2003-06-13 Thread Paul Tomsic
Is there a way to escape the SQL function SUM() from within the element in the scheme.xml file? I'm trying to do: SELECT SUM(column) FROM WHATEVER WHERE etc... but during the transform, I'm getting an error, obviously, b/c the SUM() is a function from within XSL. Thoughts? thanks __

xml/xsl transform working, but fails thru cocoon?

2003-06-11 Thread Paul Tomsic
Hi, we can't seem to make a transformation work when retrieving the data from a SQL source. We do get the XML back correctly, but when it's displayed as PDF, everything is blank. Perhaps there's something that we're missing w/r/t the way the namespaces are followed inside cocoon, but below is our s

invoke cocoon from another bean/create rpt on filesystem

2003-06-11 Thread Paul Tomsic
I'm wondering if it's possible to invoke cocoon from a bean that I've created for the purposes of having a report created in batch mode and stored on the file-system for retrieval at another time? For instance, we access our reports by simply pointing a browser to: http://whatever/reports/myReport