Hello,
I'm new with JXLS and I think I need some help to get success in this :)
I've tried to get some records from a database. There's no problem with
something like this:
<jx:forEach items="${rm.exec("select * from table where date >=
to_date('01/10/2010', 'dd/mm/yyyy') ")}" var="myVar">
But if I try to use the last_day function in the query I get an error:
<jx:forEach items="${rm.exec("SELECT LAST_DAY('01/10/2011') FROM dual")}"
var="market">
{ result : "ERROR!!", message : { text: "It was not possible to create
report id null due to:
Can't parse an expression rm.exec("SELECT LAST_DAY('01/10/2011') as fecha
FROM dual WHERE 1"). !", type: "", title: "" } }
Query is ok, if it is executed directly in the dababase.
Please, could someone help me with this? I'm really lost :(
Thanks in advance!!
------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in
Real-Time with Splunk. Collect, index and harness all the fast moving IT data
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business
insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
jXLS-user mailing list
jXLS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jxls-user
