Thanks a lot Guys, great Help
On Aug 20, 5:34 am, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> You can use Criteria's custom parameter like so:
>
> $c = new Criteria();
> $c->add(RecordPeer::DATE, "MONTH(" . RecoredPeer::DATE .") = '".
> $month ."'", Criteria::CUSTOM);
>
> Regards,
>
> Jamie Learmonth
> Boxlight Media Ltd.
>
> On 20 Ago, 00:47, Hoaxz <[EMAIL PROTECTED]> wrote:
>
> > BTW I;ll like to get a Propel wise solution...
>
> > On Aug 19, 3:45 pm, Hoaxz <[EMAIL PROTECTED]> wrote:
>
> > > Hey every one.
>
> > > My problem is simple to understand but I can't find an answerd. I want
> > > to filter records by month, meaning that if in my APP the user ask for
> > > record with Month 01 (January), the search will return exaclty those
> > > records, but I can't find a way to compare the month on a DATE field
> > > with the month given.
>
> > > PseudoCode would be something like
>
> > > SELECT * FROM record WHERE MONTH(record.date) = $month
>
> > > Any help or orientation may help.
>
> > > Thanks
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
