[symfony-users] Re: Problem Filtering by Date

2008-08-20 Thread Hoaxz
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

[symfony-users] Re: Problem Filtering by Date

2008-08-20 Thread Thomas Rabaix
Take care if the value come from the user request, you should add (int)$month to avoid SQL Injection. Thomas On Wed, Aug 20, 2008 at 11:34 AM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > You can use Criteria's custom parameter like so: > > $c = new Criteria(); > $c->add(RecordPeer::DATE, "M

[symfony-users] Re: Problem Filtering by Date

2008-08-20 Thread [EMAIL PROTECTED]
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

[symfony-users] Re: Problem Filtering by Date

2008-08-19 Thread Hoaxz
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)