Actually, your version seems syntactically correct, but mine works...go figure.
Well, apparently the problem is stemming from OSX being a "UNIX" operating system, but using a non case-sensitive file system. I've experienced weird anomalies like this before where I'd have to export and recreate the table and it would work fine. -Zack -----Original Message----- From: Graaf, Edgar de (fin) [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 2:23 AM To: '[EMAIL PROTECTED]' Subject: RE: Cocoon generated Java throwing SQLException Zack, Isn't <xsp:logic> String userLogin = <xsl:value-of select="login"/>; String userPass = <xsl:value-of select="password"/>; </xsp:logic> <xsp:logic> String userLogin = "<xsl:value-of select="login"/>"; String userPass = "<xsl:value-of select="password"/>"; </xsp:logic> Regards, Edgar -----Oorspronkelijk bericht----- Van: Zack Angelo [mailto:[EMAIL PROTECTED]] Verzonden: donderdag 2 mei 2002 15:16 Aan: [EMAIL PROTECTED] Onderwerp: Re: Cocoon generated Java throwing SQLException Hmm, well, I don't think there are problems with my XSP syntax because the Java seems to be generating correctly, but I guess you're right. It could be something obscure. So here it is: <?xml version="1.0"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; xmlns:xsp="http://apache.org/xsp"; xmlns:esql="http://apache.org/cocoon/SQL/v2"; xmlns:xsp-session="http://apache.org/session/2.0"; xmlns:malin-auth="http://nostromo.com/malin-auth"; version="1.0"> <xsl:template match="xsp:page"> <xsl:copy> <xsl:apply-templates select="@*"/> <xsl:apply-templates/> </xsl:copy> </xsl:template> <xsl:template match="malin-auth:authenticate"> <xsp:logic> String userLogin = <xsl:value-of select="login"/>; String userPass = <xsl:value-of select="password"/>; </xsp:logic> <esql:connection> <esql:pool>mySql</esql:pool> <esql:execute-query> <esql:query> select ID,count(ID) as count from Users where LoginUser='zack' and Password='password' group by ID </esql:query> <esql:results> <esql:row-results> <xsp:logic> int rescount = <esql:get-int column="count"/>; int userID = 0; if (rescount > 0) { userID = <esql:get-int column="ID"/>; } </xsp:logic> <xsp-session:set-attribute name="malin-uid"><xsp:expr>userID</xsp:expr></xsp-session:set-attribute> </esql:row-results> </esql:results> </esql:execute-query> </esql:connection> </xsl:template> <xsl:template match="malin-auth:get-userid"> <xsp-session:get-attribute name="malin-uid"/> </xsl:template> <xsl:template match="@*|node()" priority="-1"> <xsl:copy> <xsl:apply-templates select="@*|node()"/> </xsl:copy> </xsl:template> </xsl:stylesheet> On 5/2/02 2:12 AM, "Graaf, Edgar de (fin)" <[EMAIL PROTECTED]> wrote: > 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]> > > --------------------------------------------------------------------- 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]> --------------------------------------------------------------------- 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]>
