check whether the boolean value true or false

i have a table called “confirm_clients”,there are 3

columns,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

Ishara Gunathilake 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

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

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

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

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 Biedenharn http://agileconsultingllc.com Rob@AgileConsultingLLC.com