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

[Irving Salisbury III]

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]