$c->add(CharPeer::SENDER, array($rsender), Criteria::NOT_IN)
On Aug 20, 4:10 am, Güyçmyrat Amanmyrat <[EMAIL PROTECTED]>
wrote:
> Hello. How can i write this query with Criteria ?
>
> $sql = "SELECT Chat.SENDER, Chat.RECIEVER FROM Chat WHERE Chat.OWNER=38 AND
> Chat.SENDER NOT IN(14) AND Chat.SENDDT>='2008-08-20 10:19:06' AND
> Chat.STAT='0' GROUP BY Chat.SENDER"
>
> This $sql works. When i try it with Criteria it is not working.
>
> What is the problem ?
> I guess problem is with
> Chat.SENDER NOT IN(14) => $c->add(ChatPeer::SENDER, $rsender,
> Criteria::NOT_EQUAL );
>
> How can i correct the mistake ? Thanks.
>
> $c = new Criteria();
> $c->addSelectColumn(MinchatPeer::R);
> $this->minrs = ChatPeer::doSelectRS($c);
> $rsender = array();
>
> while ($this->minrs->next())
> {
> $rsender[] = $this->minrs->getInt(1);
> }
>
> $c = new Criteria();
> $c->clearSelectColumns();
> $c->addSelectColumn(ChatPeer::SENDER );
> $c->add(ChatPeer::SENDER, $rsender, Criteria::NOT_EQUAL );
> $c->add(ChatPeer::SENDDT ,date('Y-m-d H:i:s',strtotime("now -$check
> minutes")),Criteria::GREATER_EQUAL );
> $c->add(ChatPeer::STAT , '0');
>
> __________________________________________________
> Yahoo! kullanıyor musunuz?
> İstenmeyen postadan bıktınız mı? Yahoo! Posta'da piyasanın en iyi istenmeyen
> posta korunması varhttp://tr.mail.yahoo.com
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
