# Syntax for db count query needed

**URL:** <https://www.ruby-forum.com/t/syntax-for-db-count-query-needed/80538>\
**Category:** Ruby\
**Created:** [December 28, 2006, 3:36pm UTC](https://www.ruby-forum.com/t/syntax-for-db-count-query-needed/80538 "2006-12-28T15:36:35Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rubyquest](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/59ef9b/32.png) [@rubyquest](https://www.ruby-forum.com/u/rubyquest)\
**Post date:** [December 28, 2006, 3:36pm UTC](https://www.ruby-forum.com/t/syntax-for-db-count-query-needed/80538/1 "2006-12-28T15:36:35Z")

</div>

can any one tell me the controller syntax for db record count?

I want to specify this mysql query syntax in controller

select count(\*) from tablename where user\_id=7;

what is the controller syntax similar to the above sql quert?

thanks and regards  
Rubyquest

---

<div class="post-metadata">

**Author:** ![rubyquest](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/59ef9b/32.png) [@rubyquest](https://www.ruby-forum.com/u/rubyquest)\
**Post date:** [December 28, 2006, 4:20pm UTC](https://www.ruby-forum.com/t/syntax-for-db-count-query-needed/80538/2 "2006-12-28T16:20:11Z")

</div>

On Thu, 28 Dec 2006, Ruby Q. wrote:

> can any one tell me the controller syntax for db record count?
> 
> I want to specify this mysql query syntax in controller
> 
> select count(\*) from tablename where user\_id=7;
> 
> what is the controller syntax similar to the above sql quert?

Sure! I do it like this:

count = ksdbh.count(:Tablename) {|r| r.user\_id == 7}

Other people probably do it differently, though. Details are important  
when asking a “How do I…?” question.

I imagine that you are actually asking how to do that using  
ActiveRecord,  
right? If so, while you will probably get a correct answer for AR from  
someone on this list, the better place to ask those questions is the  
Rails  
list.

Thanks,

Kirk H.

---

<div class="post-metadata">

**Author:** ![rubyquest](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/59ef9b/32.png) [@rubyquest](https://www.ruby-forum.com/u/rubyquest)\
**Post date:** [December 28, 2006, 4:28pm UTC](https://www.ruby-forum.com/t/syntax-for-db-count-query-needed/80538/3 "2006-12-28T16:28:20Z")

</div>

Thanks kirk Haines!

```
It works...

```

Thanks again  
Rubyquest

---

<div class="post-metadata">

**Author:** ![rubyquest](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/59ef9b/32.png) [@rubyquest](https://www.ruby-forum.com/u/rubyquest)\
**Post date:** [December 28, 2006, 4:32pm UTC](https://www.ruby-forum.com/t/syntax-for-db-count-query-needed/80538/4 "2006-12-28T16:32:17Z")

</div>

On Fri, 29 Dec 2006, Ruby Q. wrote:

> Thanks kirk Haines!
> 
> It works…
> 
> Thanks again

That works for you? What ORM are you using? That was not AR syntax,  
but  
rather, syntax for the Kansas ORM.

Kirk H.

---

<div class="post-metadata">

**Author:** ![rubyquest](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/59ef9b/32.png) [@rubyquest](https://www.ruby-forum.com/u/rubyquest)\
**Post date:** [December 29, 2006, 10:40am UTC](https://www.ruby-forum.com/t/syntax-for-db-count-query-needed/80538/5 "2006-12-29T10:40:19Z")

</div>

NO…i used below method and it works.

@itemCount=Item.count(:all, :joins=\>“my table joins goes here”,  
:conditions =\>[“my conditions goes here”];

sorry for the confusion…

Thanks  
RQ

> That works for you? What ORM are you using? That was not AR syntax,  
> but  
> rather, syntax for the Kansas ORM.
> 
> Kirk H.