Print out the criteria.toString(). It will give an incomplete sql
statement, but it will show everything after the WHERE. Does it look
correct?
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!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.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]
