Re: HAVING clause - MySQL 4.0.13 - unknown column error

2003-07-03 Thread Dan Nelson
In the last episode (Jul 03), Thomas J. Harris said: > This query does not work, giving me the following error: > Unknown column 'resource1_.COMPETENCE_LEVEL' in 'having clause' > > BUT, if I change the query so that the having clause is the following: > > having (x2_0_>? ) > > It runs fine!

HAVING clause - MySQL 4.0.13 - unknown column error

2003-07-03 Thread Thomas J. Harris
To any MySQL users, I am using an open-source object relational mapping layer from Java called Hibernate to interface with a MySQL database on my machine. I am running version 4.0.13 of the server, and SQL/J Connector version 3.0.7. The query that is generated from Hibernate looks like this: sel