# Active record quetion

**URL:** <https://www.ruby-forum.com/t/active-record-quetion/121223>\
**Category:** Ruby\
**Created:** [November 25, 2007, 5:31pm UTC](https://www.ruby-forum.com/t/active-record-quetion/121223 "2007-11-25T17:31:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Junkone](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/e274bd/32.png) [@Junkone](https://www.ruby-forum.com/u/Junkone)\
**Post date:** [November 25, 2007, 5:31pm UTC](https://www.ruby-forum.com/t/active-record-quetion/121223/1 "2007-11-25T17:31:05Z")

</div>

here is my issue. i want to get the id of of the record extracted  
here. it however gives me 37832400  
instead of 9. i am not sure why.

> > t=Trade.find\_by\_sql(“select \* from trades where tradestatus=‘O’ and symbol\_al  
> > ias=‘USD.CHF-IDEALPRO-CASH’”)  
> > =\> [#\<Trade:0x4828a80 @attributes={“tradestatus”=\>“O”,  
> > “tradestrategy”=\>nil, “sy  
> > mbol\_alias”=\>“USD.CHF-IDEALPRO-CASH”, “tradeinterval”=\>“5MINUTE”,  
> > “getpictures”=  
> > nil, “tradename”=\>nil, “id”=\>“9”, “grossrevenue”=\>nil, “tradecomments”=\>nil, “t  
> > radedirection”=\>“Long”}\>]
> 
> > t.id  
> > (irb):8: warning: Object#id will be deprecated; use Object#object\_id  
> > =\> 37832400

---

<div class="post-metadata">

**Author:** ![Junkone](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/e274bd/32.png) [@Junkone](https://www.ruby-forum.com/u/Junkone)\
**Post date:** [November 25, 2007, 6:46pm UTC](https://www.ruby-forum.com/t/active-record-quetion/121223/2 "2007-11-25T18:46:39Z")

</div>

t is an Array (see this by typing t.class)  
So, t.id is going to return a value related to the Array class as  
opposed to  
the contents.

t[0].id t[1].id etc would return what you are expecting

---

<div class="post-metadata">

**Author:** ![Junkone](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/e274bd/32.png) [@Junkone](https://www.ruby-forum.com/u/Junkone)\
**Post date:** [November 25, 2007, 8:05pm UTC](https://www.ruby-forum.com/t/active-record-quetion/121223/3 "2007-11-25T20:05:50Z")

</div>

On Nov 25, 12:45 pm, Rich Vázquez [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> > mbol\_alias"=\>“USD.CHF-IDEALPRO-CASH”, “tradeinterval”=\>“5MINUTE”,  
> > Rich Vázquez, CISSP, CISA- Hide quoted text -
> 
> - Show quoted text -

thanks for the pointer. my bad.