Problem with addAscendingOrderBy() & addDescendingOrderBy()

[Mark Vickers <ma...@yahoo.com>]

Hi folks,
I seem to have encountered a bug surrounding the use
of the order by statement.  If I don't add an order by
clause to my criteria, everything works as expected. 
When I use the criteria addAscendingOrderByColumn
method, my criteria fails to produce any results.

Here's the code:

crit = new Criteria();
crit.add(QuantitypricePeer.QUANTITY, 0,
Criteria.GREATER_THAN);
System.out.println(crit.toString());

crit.addAscendingOrderByColumn(QuantitypricePeer.QUANTITY);
System.out.println(crit.toString());


And here's the output:

Criteria::
QuantityPrice.QUANTITY<=>(QuantityPrice.QUANTITY>0):
Current Query SQL (may not be complete or applicable):
SELECT  FROM QuantityPrice WHERE
(QuantityPrice.QUANTITY>0)

Criteria::
QuantityPrice.QUANTITY<=>(QuantityPrice.QUANTITY>0):
Current Query SQL (may not be complete or applicable):

Executing the following code now generates an
exception:
qPriceVec = product.getQuantityprices(crit);

(Product is a table linked to the quantityPrice table
via a foreign key.  I'm using MySQL.)

Any suggestions?
thanks,
mark

__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>