Zack, Please provide the whole XSP.
Regards, Edgar -----Oorspronkelijk bericht----- Van: Zack Angelo [mailto:[EMAIL PROTECTED]] Verzonden: donderdag 2 mei 2002 4:55 Aan: [EMAIL PROTECTED] Onderwerp: Cocoon generated Java throwing SQLException Hey, I'm having some really peculiar behavior with the ESQL logicsheet. I have the following XSP (in my own logicsheet): <esql:query> select ID,count(ID) as count from Users where LoginUser='zack' and Password='password' group by ID</esql:query> The corresponding Java seems to be generating just fine: _esql_query = new EsqlQuery( _esql_connection, String.valueOf("select ID,count(ID) as count from Users where LoginUser='zack' and Password='password' group by ID") ); But, upon execution, I get this exception: org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.RuntimeException: Error executing statement: select ID,count(ID) as count from Users where LoginUser='zack' and Password='password' group by ID: java.sql.SQLException: Column not found: Unknown column 'LoginUser' in 'where clause' For some reason it's saying that one of the columns doesn't exist...I have no idea why. I've also copied and pasted the SQL query from the Java into the mysql client, and it works fine. Any ideas? This just seems really strange to me. Thanks in advance. -Zack Angelo Nostromo Corporation --------------------------------------------------------------------- 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]>
