# ActiveRecord find :select

**URL:** <https://www.ruby-forum.com/t/activerecord-find-select/143925>\
**Category:** Rails\
**Created:** [July 23, 2008, 10:12pm UTC](https://www.ruby-forum.com/t/activerecord-find-select/143925 "2008-07-23T22:12:44Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![micktaiwan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/4af34b/32.png) [@micktaiwan](https://www.ruby-forum.com/u/micktaiwan)\
**Post date:** [July 23, 2008, 10:12pm UTC](https://www.ruby-forum.com/t/activerecord-find-select/143925/1 "2008-07-23T22:12:44Z")

</div>

Hello,

Why using this :select, it works :

:select=\>"_, (select count(_) from `tasks` T) as subcache"

but using this one does not:

:select=\>"_, (select count(_) from `tasks` T where T.task\_id =  
`tasks`.id) as subcache"

returning this error:

ActionView::TemplateError (undefined method `subcache’ for  
#Task:0xb706bc30) on line #6 of task/\_task\_c.rhtml:  
6: \<% nb = task\_c.subcache.to\_i %\>

I have tested this query in MySQL Query Broser and it is well formed and  
works.  
select _, (select count(_) from tasks T where T.task\_id = tasks.id) as  
subcache from tasks

Thanks,  
Mickael.