On 13 November 2012 20:40, byrnejb <[email protected]> wrote:
> I am trying to determine what is going on with the following code:
>
> In AR
> def self.all_billables
>   where(  :is_billed => false )
> end
>
> returns 2 records.
>
> def self.all_billables
>   where( "is_billed" => false )
> end
>
> also returns 2 records.
>
> In sqlite3
> sqlite> select * from tests where ( "is_billed" = 'false' );
>
> returns 2 records.
>
> However, if I use these forms in AR then I get nothing returned:
>
> def self.all_billables
>   where( %Q( "is_billed" = 'false' ) )
> end
>
> def self.all_billables
>   where( "is_billed = 'false'" )
> end
>
>
> What am I missing here?

Look in log/development.log to see what the difference is in the
queries (which should be logged there).  Then it will probably make
sense.

Colin

-- 
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].
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to