Have you tried either of these in the 2.1 code?
addAscendingOrderByColumn() or
addDescendingOrderByColumn()
I've used these just this week and they work fine.
-Eric
On Monday, August 13, 2001, at 01:24 AM, Hristo Kosev wrote:
> --- John McNally <[EMAIL PROTECTED]> wrote:
>> Print out the criteria.toString(). It will give an
>> incomplete sql
>> statement, but it will show everything after the
>> WHERE. Does it look
>> correct?
>
> Actually when I print the Criteria without previously
> setting orderByColumn Criteria.toString() outputs the
> correct SQL query but when I set orderByColumn it
> doesn't output anything...?!
>
> Hristo Kosev
>
>> john mcnally
>>
>>
>>
>> Hristo Kosev wrote:
>>>
>>> Hi,
>>> I want to report that addOrderByColumn doesn't
>> work.
>>> I use Turbine v2.1(the version that comes with TDK
>>> 2.1) and MySQL v3.23.36
>>> For example if I have table TableA (with columns
>> ID
>>> and NAME) and TableAPeer class
>>> when I do:
>>>
>>> Criteria c = new Criteria();
>>> Vector records = TableAPeer.select(c, db);
>>>
>>> I get all of the records from this table but when
>> I
>>> do:
>>>
>>> Criteria c = new Criteria();
>>> c.addOrderByColumn(TableAPeer.ID);
>>> Vector records = TableAPeer.doSelect(c, db);
>>>
>>> I don't get any records. I tried with
>>> addAscendingOrderByColumn and
>>> addDescendingOrderByColumn too but there was no
>>> result. I also try to select the records as
>> village
>>> records with doSelectVillageRecords but it was all
>> the
>>> same.
>>>
>>> Hristo Kosev
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
