You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by yann petit <yp...@capgemini.fr> on 2001/01/03 16:32:06 UTC

esql/ancestor problem 

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 ?
Any Idea ?


Yann

Re: esql/ancestor problem

Posted by Donald Ball <ba...@webslingerZ.com>.
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