Re: Pass true or false as condition

2010-09-08 Thread Shaz
Also if I remember correctly cakephp doesn't read bolean from a database? http://nuts-and-bolts-of-cakephp.com/2008/10/06/cakephp-mysql-tinyint1-confusion/ On Sep 7, 10:11 pm, Miles J mileswjohn...@gmail.com wrote: Couldn't you just pass 1 and 0? Also your argument is backwards. True should

Re: Pass true or false as condition

2010-09-08 Thread j.blotus
instead of using boolean why not just use tinyint(1) On Sep 8, 6:32 am, Shaz shazam...@gmail.com wrote: Also if I remember correctly cakephp doesn't read bolean from a database? http://nuts-and-bolts-of-cakephp.com/2008/10/06/cakephp-mysql-tinyint... On Sep 7, 10:11 pm, Miles J

RE: Pass true or false as condition

2010-09-08 Thread Dave Maharaj
My setting was if you want something removed so if selected that's users setting was true so then when time to get records if user.display = true its saying do not get records where that is true If its User.setting = FALSE then I have to get 0 and 1 It sounds backwards but remove setting = true

Pass true or false as condition

2010-09-07 Thread Dave Maharaj
I am passing true or false as a condition in a find() but stumped how to pull db records based on the true or false. Basically in the db table I have a bool field If TRUE is passed as a condition I need to get only records where the bool value is ZERO, if FALSE get all ZERO and 1 records.

Re: Pass true or false as condition

2010-09-07 Thread Miles J
Couldn't you just pass 1 and 0? Also your argument is backwards. True should be 1 and false should be 0. isDeleted = true = 1 hasRelations = true = 1 On Sep 7, 2:06 pm, Dave Maharaj m...@davemaharaj.com wrote: I am passing true or false as a condition in a find() but stumped how to pull db