cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gustavo Mejia <gme...@infotec.com.mx>
Subject ESQL Cocoon problem (string length)
Date Thu, 05 Jul 2001 22:26:14 GMT
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:cordes@cs.usm.maine.edu]
> Odesláno: Monday, May 14, 2001 9:54 PM
> Komu: cocoon-users@xml.apache.org
> 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 mayer.robert@slsp.sk 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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message