cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christopher Painter-Wakefield" <paint...@mc.duke.edu>
Subject Re: SQL-Statment with two (or more) "where" statments
Date Fri, 26 Oct 2001 14:49:41 GMT

Christian,

I can't see anything wrong, but you've not shown us all your code.  Also,
we have no way of verifying that your column and table names match your
database.  One reason it is hard to debug ESQL is because all exceptions
get trapped and turned into generic exceptions, so you don't know what
actual issue the JDBC driver or database is complaining about.  You should
first ensure your queries work outside Cocoon (e.g., type them into a query
tool and see if they blow up).  You can also try building up from simple
queries that work, adding to them in small increments, e.g., one WHERE
condition at a time and so forth.  That should help you find what bit is
causing the trouble.

If you want to see what JDBC is really complaining about, you'll have to
hack the esql.xsl logicsheet to re-throw the JDBC exceptions instead of
substituting generic exceptions.

-Christopher




Please respond to cocoon-users@xml.apache.org

To:   cocoon-users@xml.apache.org
cc:

Subject:  SQL-Statment with two (or more) "where" statments


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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message