# Metodo Find e ritorno di un numero intero

**URL:** <https://www.ruby-forum.com/t/metodo-find-e-ritorno-di-un-numero-intero/172756>\
**Category:** IT\
**Created:** [July 27, 2009, 4:53pm UTC](https://www.ruby-forum.com/t/metodo-find-e-ritorno-di-un-numero-intero/172756 "2009-07-27T16:53:56Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![cozzaamara](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/3e96dc/32.png) [@cozzaamara](https://www.ruby-forum.com/u/cozzaamara)\
**Post date:** [July 27, 2009, 4:53pm UTC](https://www.ruby-forum.com/t/metodo-find-e-ritorno-di-un-numero-intero/172756/1 "2009-07-27T16:53:56Z")

</div>

Ciao a tutti,

sviluppando un mio sistema di paginato avrei bisogno di capire con Rails  
come trovare direttamente un valore intero dopo una query.

Es:  
Ho bisogno di una query che recuperi il totale dei prodotti:  
Product.find(:all, :select =\> ‘count(\*) as tot’, :from =\> ‘products’)

Io avrei bisogno di avere @tot = valore\_numerico\_intero (es: @tot = 35)

E’ possibile? Qual’è il modo più elegante ed efficace per una cosa  
simile?

Grazie mille.

---

<div class="post-metadata">

**Author:** ![cozzaamara](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/3e96dc/32.png) [@cozzaamara](https://www.ruby-forum.com/u/cozzaamara)\
**Post date:** [July 27, 2009, 4:58pm UTC](https://www.ruby-forum.com/t/metodo-find-e-ritorno-di-un-numero-intero/172756/2 "2009-07-27T16:58:19Z")

</div>

Product.count

# =\> 35

2009/7/27 Cozza A. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

> Product.find(:all, :select =\> ‘count(\*) as tot’, :from =\> ‘products’)

–  
Simone C.

Site & Blog: [http://www.simonecarletti.com](http://www.simonecarletti.com)  
Email: removed\_email\_address@domain.invalid  
LinkedIn: [http://linkedin.com/in/weppos](http://linkedin.com/in/weppos)  
Nick: weppos | Skype: weppos

---

<div class="post-metadata">

**Author:** ![cozzaamara](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/3e96dc/32.png) [@cozzaamara](https://www.ruby-forum.com/u/cozzaamara)\
**Post date:** [July 27, 2009, 4:59pm UTC](https://www.ruby-forum.com/t/metodo-find-e-ritorno-di-un-numero-intero/172756/3 "2009-07-27T16:59:32Z")

</div>

Sinceramente non ho ben compreso la tua stringa ma penso che ti serva  
una cosa del tipo:

Product.count(:all,:conditions=\>…)

Luigi

---

<div class="post-metadata">

**Author:** ![cozzaamara](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/3e96dc/32.png) [@cozzaamara](https://www.ruby-forum.com/u/cozzaamara)\
**Post date:** [July 27, 2009, 5:02pm UTC](https://www.ruby-forum.com/t/metodo-find-e-ritorno-di-un-numero-intero/172756/4 "2009-07-27T17:02:46Z")

</div>

Dato che ti serve per la paginazione ti potrebbe essere utile questo  
snippet di codice che ho scritto per lo stesso tuo motivo:

if not params[:pagina]==nil  
@page=Integer(params[:pagina])  
@offset=(@page-1)\*20  
else  
@offset=0  
end

@laws\_count=Law.count(:conditions=\>“public”)  
@pages\_number=(Float(@laws\_count)/20).ceil #arrotondamento all’intero  
superiore  
if Integer(params[:pagina]) \> @pages\_number  
redirect\_to :action=\>‘not\_found’  
else  
@laws=Law.find(:all,:conditions=\>‘public’,:order=\>‘updated  
desc’,:limit=\>20,:offset=\>@offset)  
end

Luigi

---

<div class="post-metadata">

**Author:** ![cozzaamara](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/3e96dc/32.png) [@cozzaamara](https://www.ruby-forum.com/u/cozzaamara)\
**Post date:** [July 27, 2009, 5:35pm UTC](https://www.ruby-forum.com/t/metodo-find-e-ritorno-di-un-numero-intero/172756/5 "2009-07-27T17:35:41Z")

</div>

Simone C. wrote:

> Per la paginazione ti consiglio la GEM mislav-will\_paginate.  
> Fa pi� o meno quello e molto altro.
> 
> – Simone  
> Ciao Weppos,

ho provato in primis will\_paginate ma non ho capito come limitare il  
numero di pagine linkate prima e dopo la pagina corrente.

tra me le mette tutte e diventa impossibile laddove si  
abbiano decine e decine di pagine.

Es: ne vorrei solo 2 prima e dopo quella corrente (\<prev 1 2 -3- 4 5  
next\>)

Grazie ancora.

---

<div class="post-metadata">

**Author:** ![cozzaamara](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/3e96dc/32.png) [@cozzaamara](https://www.ruby-forum.com/u/cozzaamara)\
**Post date:** [July 27, 2009, 5:05pm UTC](https://www.ruby-forum.com/t/metodo-find-e-ritorno-di-un-numero-intero/172756/6 "2009-07-27T17:05:20Z")

</div>

Per la paginazione ti consiglio la GEM mislav-will\_paginate.  
Fa più o meno quello e molto altro.

– Simone

On Mon, Jul 27, 2009 at 5:02 PM, Luigi M. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> ## @laws\_count=Law.count(:conditions=\>“public”) Luigi
> 
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).
> 
> * * *
> 
> Ml mailing list  
> removed\_email\_address@domain.invalid  
> [http://lists.ruby-it.org/mailman/listinfo/ml](http://lists.ruby-it.org/mailman/listinfo/ml)

–  
Simone C.

Site & Blog: [http://www.simonecarletti.com](http://www.simonecarletti.com)  
Email: removed\_email\_address@domain.invalid  
LinkedIn: [http://linkedin.com/in/weppos](http://linkedin.com/in/weppos)  
Nick: weppos | Skype: weppos

---

<div class="post-metadata">

**Author:** ![cozzaamara](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/3e96dc/32.png) [@cozzaamara](https://www.ruby-forum.com/u/cozzaamara)\
**Post date:** [July 27, 2009, 6:18pm UTC](https://www.ruby-forum.com/t/metodo-find-e-ritorno-di-un-numero-intero/172756/7 "2009-07-27T18:18:31Z")

</div>

Guarda la documentazione del metodo will\_paginate all’interno di  
/lib/will\_paginate/view\_helpers.  
Offre diverse opzioni tra cui :inner\_window e :outer\_window che fanno al  
caso tuo.

– Simone

2009/7/27 Yuri R. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

> tra me le mette tutte e diventa impossibile laddove si  
> removed\_email\_address@domain.invalid  
> [http://lists.ruby-it.org/mailman/listinfo/ml](http://lists.ruby-it.org/mailman/listinfo/ml)

–  
Simone C.

Site & Blog: [http://www.simonecarletti.com](http://www.simonecarletti.com)  
Email: removed\_email\_address@domain.invalid  
LinkedIn: [http://linkedin.com/in/weppos](http://linkedin.com/in/weppos)  
Nick: weppos | Skype: weppos