From: "Rich Vázquez" Date: 2007-11-26T02:45:55+09:00 Subject: Re: active record quetion. ------=_Part_2463_11865768.1196012755523 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 t= o the contents. t[0].id t[1].id etc would return what you are expecting On Nov 25, 2007 10:29 AM, Junkone wrote: > 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=3DTrade.find_by_sql("select * from trades where tradestatus=3D'O' an= d > symbol_al > ias=3D'USD.CHF-IDEALPRO-CASH'") > =3D> [#"O", > "tradestrategy"=3D>nil, "sy > mbol_alias"=3D>"USD.CHF-IDEALPRO-CASH", "tradeinterval"=3D>"5MINUTE", > "getpictures"=3D > >nil, "tradename"=3D>nil, "id"=3D>"9", "grossrevenue"=3D>nil, > "tradecomments"=3D>nil, "t > radedirection"=3D>"Long"}>] > >> t.id > (irb):8: warning: Object#id will be deprecated; use Object#object_id > =3D> 37832400 > >> > > > > --=20 -- Rich V=E1zquez, CISSP, CISA ------=_Part_2463_11865768.1196012755523--