Subject: [xsl] esql does not handle to_date function in SQL From: "Ibeling, Narisa" <narisa.h.ibeling@xxxxxxxxxxxxx> Date: Thu, 31 Oct 2002 14:06:57 -0600 |
Hi, there. Here is my xml source: <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0"> <sql:use-connection>personnel</sql:use-connection> <sql:query> select count(pt) from adv_7760$rollsnap.thro where study = 'ADV_7760' and vpos = 'aortic' and to_date(event_date,'yyyymmdd') - to_date(implant_date,'yyyymmdd') <= 30 and thrombosed_etiology = 'primary event' </sql:query> </sql:execute-query> I am using cocoon to transform the results into xml. My problem is cocoon is confused with to_date function. It cannot process the query. If I take the line with the to_date function, it works. Is there any way I can accomplish the query in other ways? Thanks in advance for your help. Narisa Ibeling Medtronic Cardiac Surgery XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] Using substring call with, Michael Kay | Thread | [xsl] Re: variables in XSLT, karan bhasin |
[xsl] Using substring call with for, Alan K. Gay | Date | RE: [xsl] Delete XML Node, Deepak Rao |
Month |