Re: [Rails] Proper use of the where method om ActiveRecord.

On Tuesday, November 13, 2012 4:16:17 PM UTC-5, Colin Law wrote:

By using :is_billed => false you are telling rails that you want the
value to be whatever rails uses as the logical value false (which
appears to be "f").  By specifying yourself that the contents of the
column must be the string "false" it does not find the records.

I am a bit surprised that the sqlite example you gave works.  Are you
sure you entered the query exactly as you showed?  I am not that
familiar with sqlite however.

It appears that sqlite3 does not have a concept of a boolean type.  I find that you can put literally any string into a boolean column in an sqlite3 database.  As I was testing in sqlite with data rows I had inserted having is_billed values ( 'false' ) selecting where ( "is_billed" = 'false' ) naturally worked.  Ah well, live and learn.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/oFaYZ8VflLoJ.
For more options, visit https://groups.google.com/groups/opt_out.