HI !
Any news about this issue ??
Thanks!!
Gustavo Mejia wrote:
> 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]>
--
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]>
