On Monday, January 21, 2002, at 12:02 AM, Sorin Scortan wrote: > I used addAscendingOrderByColumn() too, but the exception is still > there...
Then the problem is somewhere else... >> On Friday, January 18, 2002, at 06:39 AM, Sorin Scortan wrote: >> >>> Criteria crit = new Criteria(); >>> crit.add(CategoryPeer.LEVEL, 1, (String)Criteria.EQUAL); >>> crit.addOrderByColumn(CategoryPeer.CATEGORYID); If the schema you gave earlier is correct then I think you should be using 'CategoryPeer.ID' instead of 'CategoryPeer.CATEGORYID'. The CATEGORYID column doesn't exist in the schema you posted: > <table name="category"> > <column name="id" required="true" autoIncrement="true" > primaryKey="true" type="INTEGER"/> > <column name="parentid" required="true" type="INTEGER"/> > <column name="level" required="true" type="INTEGER"/> > <column name="status" required="true" default="A" size="1" > type="VARCHAR"/> > </table> -Eric -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
