Ahhh yes, didn't spot that it might be multiple criteria on the same column. Thats probably your problem Parijat. Unfortunately (or fortunately depending on how you look at it), Propel by default overrides the criteria of a column of you change the criteria on it. Use of Criterions on that case is compulsory.
On Tue, Oct 26, 2010 at 10:25 PM, pghoratiu <[email protected]> wrote: > When using multiple conditions on the same column you need to use a > criterion that links them together otherwise the last defined > filtering criteria is taken into consideration. > > Using your example something like this: > $c = new Criteria(); > $c1 = $c- > >getNewCriterion((CommentsPeer::COMMENT,'likes',Criteria::NOT_LIKE); > $c2 = $c->getNewCriterion(CommentsPeer::COMMENT,'%likes > %',Criteria::NOTLIKE); > $c1->addAnd($c2); > > $c->add($c1); > > gabriel > > On Oct 26, 3:16 am, Parijat Kalia <[email protected]> wrote: > > Hey guys, trying to implement a criteria for my sql query which has a not > > like clause in it. > > this is how I proceed: > > > > $c->add(CommentsPeer::COMMENT,'likes',Criteria::NOTLIKE); > > > > I have also carried out trial and error with the following: > > > > $c->add(CommentsPeer::COMMENT,'likes',Criteria::NOT_LIKE); > > $c->add(CommentsPeer::COMMENT,'%likes%',Criteria::NOTLIKE); > > $c->add(CommentsPeer::COMMENT,'%likes%',Criteria::NOT_LIKE); > > > > also made use of not_equal > > > > $$c->add(CommentsPeer::COMMENT,'likes',Criteria::NOTEQUAL); > > $c->add(CommentsPeer::COMMENT,'likes',Criteria::NOT_EQUAL); > > > > None of these work, neither are they causing any background errors in the > > action within which they are called. Yet they always yield the 'likes' > query > > in the results. > > > > Not sure what I am doing wrong here, would anybody like to point out any > > errors? > > > > Regards, > > > > Parijat Kalia > > -- > If you want to report a vulnerability issue on symfony, please send it to > security at symfony-project.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]<symfony-users%[email protected]> > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en > -- Gareth McCumskey http://garethmccumskey.blogspot.com twitter: @garethmcc -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.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
