Check whether the boolean value true or false


#1

i have a table called “confirm_clients”,there are 3columns,they are
t.column :user_id, :string
t.column :msg_id, :string
t.column :confirm, :boolean

i want to check whether the boolean value of confirm is true
when a given user_id and msg_id,plz can anyone how can i do it


#2

Ishara G. wrote:

i have a table called “confirm_clients”,there are 3columns,they are
t.column :user_id, :string
t.column :msg_id, :string
t.column :confirm, :boolean

i want to check whether the boolean value of confirm is true
when a given user_id and msg_id,plz can anyone how can i do it

try to use “before_save” in model class


#3

assuming 0 as false and 1 as true. Try it out
confirm_client=ConfirmClient.find(5) # I am supposing the client with
id 5
if confirm_client.confirm==1 #yes indeed this client is verified
do_something
else #not verified client
do_something_else probably redirect to some place with
flash[:notice]
end

On Nov 1, 10:58 am, “Ishara G.” removed_email_address@domain.invalid


#4

On Nov 1, 7:54 am, mrbless removed_email_address@domain.invalid wrote:

assuming 0 as false and 1 as true. Try it out
confirm_client=ConfirmClient.find(5) # I am supposing the client with
id 5

How true/false are represented in the DB is database dependant. You
don’t need to worry about that though - confirm_client.confirm is
typecasted by rails to either true or false no matter what the
underlying column stores (t/f, 0/1, Y/N etc…)

Fred


#5

On Nov 1, 2008, at 8:52 AM, Frederick C. wrote:

Fred
But, I’ve found that you almost always want to replace:
t.column :confirm, :boolean
with
t.column :confirm, :boolean, :default => false, :null => false

Unless you need the SQL NULL to mean something other than “not
true” (because it is also “not false”)

Otherwise, something like:

ConfirmClient.find(:all, :conditions => { :confirm => [true,
false] })

Does NOT find all the records. This is usually when you begin to
question your sanity until discovering the NULL values in the
‘confirm’ column.

-Rob

Rob B. http://agileconsultingllc.com
removed_email_address@domain.invalid