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
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
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.” [email protected]
On Nov 1, 7:54 am, mrbless [email protected] 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
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
[email protected]