Re: Getting conditions Data for View

You are doing two finds and it is the last one (paginate) that is being returned to the view. Comment that out and see what happens.

You also didn't ought to hard code the value 2; you ought to pass it in as a variable, something like this:

public function sorted($eventId = null) {

if ($this->Session->read('Event.active') == NULL) {

$this->redirect(array('action' => 'index'));

} else {

if ($eventId) {

$jobs = $this->Job->find(

'list',

array(

'conditions' => array('Job.event_id' => $eventId)

)

);

} else {

$jobs = $this->Job->find('list');

}

$this->set('jobs', $jobs);

}

}

Jeremy Burns

Class Outfit

http://www.classoutfit.com

On 5 Mar 2013, at 17:06:15, Jerome Walitzek <jerome.walitzek@t-online.de> wrote:

Hi there,

i have a view which reads all data from database (find'list')

now i would like to get only the data with the event_id '2" 

so i have created a own view 'sorted'

in the controller i use following

public function sorted() {

if ($this->Session->read('Event.active') == NULL) {

$this->redirect(array('action' => 'index'));

} else {

$jobs = $this->Job->find('list', array('conditions' => array('Job.event_id' => '2')));

$this->set('jobs', $this->paginate());

}

}

But the problem, i always get all data.

any ideal how i can read out only the data with the Job.event_id = 2 values ??

Thx for help

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.