Re: escape SUM function from within sql:query in scheme.xml??
SUM() most CERTAINLY is a function in XSL. From page 554 of WROX, XSLT 2nd Edition, Programmer's Reference by Michael Kay, The sum() function calculates the total set of numeric values contained in a node-set. For example, if the context node is the element rect x=20 y=30/ then the expression sum(@*) returns 50. Now HOW are you going to tell me that SUM() isn't an XSLT function? When I remove the sum() from my SQL query, however, and simply use it from within the XSL page, I'm fine. I was just wondering what the best way to escape sql functions like SUM() 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 sql:query element in the scheme.xml file? I'm trying to do: sql:query SELECT SUM(column) FROM WHATEVER WHERE etc... /sql:query but during the transform, I'm getting an error, obviously, b/c the SUM() is a function from within XSL. Thoughts? thanks __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: escape SUM function from within sql:query in scheme.xml??
Paul Tomsic wrote: SUM() most CERTAINLY is a function in XSL. From page 554 of WROX, XSLT 2nd Edition, Programmer's Reference by Michael Kay, The sum() function calculates the total set of numeric values contained in a node-set. For example, if the context node is the element rect x=20 y=30/ then the expression sum(@*) returns 50. Now HOW are you going to tell me that SUM() isn't an XSLT function? Calm down! XML and so XSLT is case-sensitive, so SUM() is not a XSLT function, but sum(). This difference is important! And there is still the fact, that you wrote it as text and not as expression in the XSLT meaning. Joerg When I remove the sum() from my SQL query, however, and simply use it from within the XSL page, I'm fine. I was just wondering what the best way to escape sql functions like SUM() would be using cocoon? Paul Tomsic wrote: Is there a way to escape the SQL function SUM() from within the sql:query element in the scheme.xml file? I'm trying to do: sql:query SELECT SUM(column) FROM WHATEVER WHERE etc... /sql:query but during the transform, I'm getting an error, obviously, b/c the SUM() is a function from within XSL. Thoughts? thanks - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: escape SUM function from within sql:query in scheme.xml??
I have used sum in all of my sql:query elements, and they go through the transformer fine. I am looking over my files now, and have probably about 20+ queries that all use sum. I didn't have to escape them out. Can you send the error you are getting? Irv Paul Tomsic wrote: Is there a way to escape the SQL function SUM() from within the sql:query element in the scheme.xml file? I'm trying to do: sql:query SELECT SUM(column) FROM WHATEVER WHERE etc... /sql:query but during the transform, I'm getting an error, obviously, b/c the SUM() is a function from within XSL. Thoughts? thanks __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com - 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: escape SUM function from within sql:query in scheme.xml??
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 sql:query element in the scheme.xml file? I'm trying to do: sql:query SELECT SUM(column) FROM WHATEVER WHERE etc... /sql:query but during the transform, I'm getting an error, obviously, b/c the SUM() is a function from within XSL. Thoughts? thanks - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]