Thanks, it works now for me.

My real problem is to actually change my admin generator to only
display items from specific user, and so I create an overriding
function at  apps/<app>/modules/message/actions/actions.class.php to
have this;

class messageActions extends autoMessageActions
{

  public function executeIndex(sfWebRequest $request)
  {
#    $this->message_list = Doctrine::getTable('Message')
#      ->createQuery('a')
#      >where('a.id = ?', 1)
#      ->execute();

    $this->message_list = Doctrine_Query::create()
      ->from('Message m')
      ->where('m.id = ?', 1 )
      ->execute();

  }

}

The problem is, it is still displaying all the available records, just
as my "where" clause is not functioning. Is it that I've got the query
wrong, or I was editing the wrong file?


On Thu, May 7, 2009 at 4:13 PM, Ian P. Christian <[email protected]> wrote:
>
> 2009/5/7 Mohd Shakir bin Zakaria <[email protected]>:
>> $ symfony doctrine:dql "FROM Message m where('m.id = ?', 1)"
>
> Yeah, it's a DQL string, not the API, so you don't use place holders like that
> 'FROM Message m WHERE m.id = 1'
>
>
> --
> Blog: http://pookey.co.uk/blog
> Follow me on twitter: http://twitter.com/ipchristian
>
> >
>



-- 
Regards,

Mohd Shakir Zakaria
www.mohdshakir.net

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to