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

[Schroeter Christian <Ch...@nbg.sbs.de>]

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