[symfony-users] Re: How to compare with two column in Criteria object?

2007-10-19 Thread Fabian Lange
Yes. why zero welcome! -Ursprüngliche Nachricht- Von: symfony-users@googlegroups.com Gesendet: 19.10.07 11:10:36 An: symfony users Betreff: [symfony-users] How to compare with two column in Criteria object? The SQL statement just like: SELECT * FROM tab WHERE col1 > col2 I use

[symfony-users] Re: How to compare with two column in Criteria object?

2007-10-19 Thread noel guilbert
Hello, You can't use the add() method as-is. You must write the sql statement yourself, using the Criteria::CUSTOM option: > $c->add(Peer::A, Peer::A . Criteria::GREATER_THAN . Peer::B, Criteria::CUSTOM); On 10/19/07, Fabian Lange <[EMAIL PROTECTED]> wrote: > > > > Yes. > > why zero > > welco

[symfony-users] Re: How to compare with two column in Criteria object?

2007-10-22 Thread [EMAIL PROTECTED]
Thank you very much! On 10月19日, 下午7时50分, "noel guilbert" <[EMAIL PROTECTED]> wrote: > Hello, > > You can't use the add() method as-is. You must write the sql statement > yourself, using the Criteria::CUSTOM option: > > > $c->add(Peer::A, Peer::A . Criteria::GREATER_THAN . Peer::B, > Criteria::CU