# Dynamic Finders Return nil

**URL:** <https://discuss.rubyonrails.org/t/dynamic-finders-return-nil/64697>\
**Category:** rubyonrails-core\
**Created:** [August 4, 2012, 7:05pm UTC](https://discuss.rubyonrails.org/t/dynamic-finders-return-nil/64697 "2012-08-04T19:05:08Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Colin\_Law1](https://avatars.discourse-cdn.com/v4/letter/c/91b2a8/32.png) [@Colin\_Law1](https://discuss.rubyonrails.org/u/Colin_Law1)\
**Post date:** [August 4, 2012, 7:05pm UTC](https://discuss.rubyonrails.org/t/dynamic-finders-return-nil/64697/1 "2012-08-04T19:05:08Z")

</div>

> Hello,
> 
> Using sqlite3, rails 3.2.2, ruby 1.9.3p125 (on windows XP)
> 
> Having the record in the db:
> 
> Shop.find(123) - returns the shop Shop.where(:id =\> 123) - returns the shop but Shop.find\_by\_id(123) returns nil same for find\_by\_name, etc.

What does the log show for the sql used when you do those?

Colin