Did you try turning on debug mode and see how the SQL statement looks
like? Try running the sql statement manually and you should be able to
track where the problem is.
Zonium
On Dec 7, 5:30 pm, sanderken <[EMAIL PROTECTED]> wrote:
> People looking for the answer to " defining limit row in oracle " :
>
> in the model , use the
> 'conditions' => ' WHERE ROWNUM <= 3 '
> option.
>
> Limit is the implementation in mySQL.
> Hope this helps someone...
>
> On 8 dec, 01:53, sanderken <[EMAIL PROTECTED]> wrote:
>
> > Maybe I should mention I'm using oracle for DBMS.
>
> > On 7 dec, 21:54, sanderken <[EMAIL PROTECTED]> wrote:
>
> > > Hey,
>
> > > I defined a "user" (named Gebruiker in my native language ) model
> > > where when I call a $this->find() , needs to retrieve only a limited
> > > amount of related information.
>
> > > When I add the 'limit' => '10' to the association info, it doesn't
> > > work. For example: I call
> > > $gebruiker = $this->find(
> > > array("Gebruiker.id" => $gebruikerid)
> > > );
> > > in the model and it retrieves 11 'kommentaars'.
>
> > > Does anyone know why this happens? I searched the internet for model
> > > information, and even the example
> > > onhttp://manual.cakephp.org/chapter/modelsshowthesame way of doing
> > > this. But it works in their example and not in my situation ;)
>
> > > Does anyone know how to solve this problem?
>
> > > Thanks,
>
> > > Here's the code:
>
> > > class Gebruiker extends AppModel
> > > {
> > > var $name = 'Gebruiker';
>
> > > var $hasMany = array(
> > > 'Blog' => array(
> > > 'className' => 'Blog',
> > > 'order' => 'Blog.created DESC',
> > > 'limit' => '10',
> > > 'foreignKey' => 'gebruiker_id',
>
> > > ),
> > > 'Kommentaar' => array(
> > > 'className' => 'Kommentaar',
> > > 'order' => 'Kommentaar.created DESC',
> > > 'limit' => '5',
> > > 'foreignKey' => 'gebruiker_id'
> > > ),
> > > 'Message_sent' => array(
> > > 'className' => 'Message',
> > > 'order' => 'Message_sent.created DESC',
> > > 'limit' => '10',
> > > 'foreignKey' => 'sender_id',
> > > ),
> > > 'Message_received' => array(
> > > 'className' => 'Message',
> > > 'order' =>
> > > 'Message_received.created DESC',
> > > 'limit' => '10',
> > > 'foreignKey' => 'receiver_id',
> > > )
> > > );
> > > <!-- Model logic here -->
>
> > > }
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
