On Wed, Mar 11, 2009 at 10:59 PM, Dave Maharaj :: WidePixels.com <d...@widepixels.com> wrote: > I been at this for hours and still no luck. What I am trying to do is run a > simple query to find a user_id based on the Auth->id and pass the result to > the view. > > This is being run in the students_controller which is checking the TEACHERS > table. In the view where I have wantsAccess all that gets displayed is > "Array". > > view: <?php echo $wantsAccess; ?>
<?php debug($wantsAccess); ?> > > $this->set('wantsAccess', $this->Teacher->find('all', array( 'conditions' => > array('Teacher.user_id' => $this->Auth->user('id')),'fields' => > array('Teacher.id') > ) > )); If you want just a single row, use find('first', ...). If you really want just the ID, use the field() method: $this->set( 'wantsAccess', $this->Teacher->field( 'id', array( 'Teacher.user_id' => $this->Auth->user('id') ) ) ); This will return just the ID (no array). Note that you don't put the 'conditions' key because that 2nd param is *only* for conditions. Another bit of advice: I've gotten in the habit of naming my vars much more specifically (ie. $user_id rather than $wantsAccess) in order to keep things clearer months down the road when I need to make changes (and curse my lack of comments ;-) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---