--- 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]
