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 [email protected]. To unsubscribe from this group, send email to [email protected]. 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.
