Thanks again, That works perfectly the way I want. I really appreciate your help and advice.
Dave -----Original Message----- From: brian [mailto:[email protected]] Sent: March-12-09 1:20 AM To: [email protected] Subject: Re: Custom Query On Wed, Mar 11, 2009 at 10:59 PM, Dave Maharaj :: WidePixels.com <[email protected]> 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 [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 -~----------~----~----~----~------~----~------~--~---
