cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <ba...@webslingerZ.com>
Subject Re: esql/ancestor problem
Date Thu, 04 Jan 2001 05:41:04 GMT
On Wed, 3 Jan 2001, yann petit wrote:

> Hi again,
>
> I have another (perhaps also stupid...) problem,
> I've seen that it's possible to do something like :
>
> <esql:execute-query>
>     <esql:driver>sun.jdbc.odbc.JdbcOdbcDriver</esql:driver>
>     ...
>     <esql:query> SELECT ... FROM ...;</esql:query>
>     <esql:results>
>         <RESULTS>
>             <A>
>                 <esql:get-string column="A"/>
>             </A>
>             <B>
>                 <esql:execute-query>
>                     <esql:driver>sun.jdbc.odbc.JdbcOdbcDriver</esql:driver>
>                     ...
>                     <esql:query> SELECT  ... FROM ... WHERE B_A =
> '<esql:get-string column="A" ancestor="1"/>';</esql:query>
>                     <esql:results>
>
>             ...
>
>
> But it doesn't seem to work and cocoon return a 'No Data Found' Error ...
> Is it possible that the problem comes from the JdbcOdbcDriver ?

two problems:

1. you're using an old version of the esql logicsheet. the schema has
changed somewhat. download the latest one from cvs.

2. you're using the jdbc odbc driver. i'd bet my left tit that that inane
piece of junk won't let you execute two queries on the same connection at
the same time. chuck it. try mysql for win32 if you're stuck on that
platform.

- donald


Mime
View raw message