Re: searching users table with token = NULL

thanks Reuben,... 

after all,... (in case someone needs it) this works for me: 

this is my form: 

<?php echo $this->Form->create('User', array('url' => 'find', 'div' => false)); ?>

<span style="float: left; text-align: left; margin: 20px 5px 0 5px;  width: 100px; ">

<?php $value = array('yes' => __('yes', true), 'no' => __('no', true)); ?>

<?php echo $this->Form->select('activated', $value, null, array('div' => false, 'empty' => 'activated' ))  ?>

</span>

     <div style="float: left; text-align: left; margin: 0 0 0 20px;">

<?php echo $this->Form->end('Search', array('div' => false)); ?>

    </div>

and here is the controller code: 

elseif(!empty($this->data['User']['activated'])) 

{

$this->paginate = array('User' => array('conditions' => array('User.token IS' . ($this->data['User']['activated'] == 'yes' ? '' : ' NOT') . ' ' . 'NULL' ), 'limit' => 24, 'order' => array('User.created' => 'DESC')));

      $users = $this->paginate('User');

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

} 

the cake is Rocks !!!

On Friday, May 10, 2013 8:09:39 PM UTC-7, Reuben wrote:

I would advise expanding that condition code, as it's hard to read. Or just arrange it a bit differently.

Currently, you'll end up with User.token LIKE IS NULL or User.token LIKE NULL, and neither of those will work with regular SQL.  CakePHP is smart enough to recognise equality or inequality with nulls, so you could do the following:

        $this->paginate = array('User' => array('conditions' => array('User.token ' . $this->data['User']['activated'] == 'yes' ? '' : '!=' => NULL )));

Essentially, this determines what operator to use, depending on User.activated.  A value of yes results in equality with null, otherwise inequality with null, and CakePHP will correctly result in User.token IS NULL or User.token IS NOT NULL.

Regards

Reuben Helms

On Thursday, 9 May 2013 20:37:15 UTC+10, Chris wrote:

hi guys,... can anyone help please,... 

I trying to search users table werther's user token IS NULL or NOT (what it means is user activated, confirmed or not) 

having some problem with coding,... 

        $this->paginate = array('User' => array('conditions' => array('User.token LIKE'=>'IS'.($this->data['User']['activated'] == 'yes' ? '' : 'NOT') . ' NULL' )));

thanks in advance 

chris

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