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 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
