Hello !!
I have the same problem that Matthew had, did someone get the solution
?? how can I fix it ??
Thanks for your help !!
*********************************************************************************************
Hi Matthew,
It looks like the column that is causing problems is of type VARCHAR2
with a
size of 64. I have a sneaking suspision that this is what is causing my
problem. I use the following code. POPIS is the problem column that I
think is causing the problem:
<!-- QUERY FOR ALL CODES -->
<esql:connection>
<esql:pool>default</esql:pool>
<esql:execute-query>
<esql:query>
select CSKS_ID CSKS_ID1, POPIS POPIS1,
TO_CHAR(PLATNOST_OD,'DD.MM.YYYY') PLATNOST_OD1
from cis_konst_symbol
order by POPIS
</esql:query>
<esql:results>
<esql:row-results>
<row>
<csks_id1><esql:get-string column="CSKS_ID1"/></csks_id1>
<popis1><esql:get-string column="POPIS1"/></popis1>
<platnost_od1><esql:get-string
column="PLATNOST_OD1"/></platnost_od1>
</row>
</esql:row-results>
</esql:results>
<esql:no-results>
<row><csks_id1> </csks_id1></row>
</esql:no-results>
</esql:execute-query>
</esql:connection>
I think the column is too big--like a blob datatype.
Regards,
Robert Mayer
> -----Původní zpráva-----
> Od: Matthew Cordes [SMTP:[EMAIL PROTECTED]]
> Odesláno: Monday, May 14, 2001 9:54 PM
> Komu: [EMAIL PROTECTED]
> Předmět: Re: ESQL Cocoon problem
>
> Hi,
>
> What datatype are you storing your data in? I had this problem with a
> clob, which I was treating as though it was a string (e.g.
> <ResultSet>.getString() ). If this is the case oracle has some special
> clob/blob releated methods/classes, read the html documentation
> that comes with the server.
>
> -matt
>
>
> On Mon, May 14, 2001 at 01:57:06PM -0400, Donald Ball wrote:
> > On Mon, 14 May 2001 [EMAIL PROTECTED] wrote:
> >
> > > I have a problem with the HTML table being cut off in my combined
> XML/XSL
> > > file. I use ESQL tags and do a query (The query does work
properly in
> > > Oracle SQL Plus.) in our Oracle database. Using Cocoon, I put the
> column
> > > results into a HTML table and the data is cut off at some point in
the
> > > table. Also when I look at the raw data coming through, the data
gets
> cut
> > > of at about row 30 and there should be about 200 rows displayed
from
> the
> > > query. In my select statement I query 3 columns. When I comment
out
> the 2nd column of the HTML table all the data (minus that column) are
> presented in the combined XML file OK. In summary, Cocoon is not able
to
> display all the data that is presented by the query using ESQL tags?
Why is this?
> Have there been similar problems reported? Is there a fix?
> >
> > there are no limitations on query size using esql.
> >
> > - donald
> >
--
Gustavo Mejía Mora
INFOTEC
Tel: 5624 28 00
Ext: 253
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>