[xsl] esql does not handle to_date function in SQL

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";>
           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'

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