Hi,

i use cocoon1.8.2. Now i have a little problem:

i want to query my db like this:

<esql:connect>
...
        <esql:connect>
        ...
          SELECT
                           a.name
                        FROM
                           a, b
                        WHERE
                b.fk2 = a.pk
                AND     
                            b.fk1 = <esql:parameter type="string"> 
<esql:get-string ancestor="1" column="fk_x"/> </esql:parameter>
        ...
        </esql:connection>
</esql:connection>

But i get the errormessage:

Error executed prepared statement: SELECT a.name FROM a, b WHERE b.fk2 = a.pk 
AND b.fk1 = ?

When i only use one where statment it works, but with 2 it wount

What must i change ?


cu
Christian

---------------------------------------------------------------------
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]>

Reply via email to