Hi Christopher, now it works...
...after i restarted tomcat and apache and then my server :-] it works...i dont know why... on the same day i got the errormessage that the code cannot be compiled and since that errormessage nothing worked anymore...because of this i restarted everything...mybe there is a context between both events...???.... sorry for the "excitement" i produced with my question... cu, christian Am Freitag, 26. Oktober 2001 16:49 schrieben Sie: > 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]> --------------------------------------------------------------------- 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]>