displaying values from query result in rails

58 views
Skip to first unread message

amruby

unread,
Jun 25, 2012, 11:15:00 AM6/25/12
to rubyonra...@googlegroups.com
i have one query, which gives the correct output in query browser.

    @getquery = Cname.select("cnames.name").where('skills.rate= ? AND skills.skill= ?',3,@searchstring).joins('JOIN skills ON cnames.id = skills.company_id')
   when i print the @getquery, it gives 

#<Cname:0x00000003f511f0>
#<Cname:0x00000003e8aa28> 

how to get the name from this @getquery?

Thanks

Oscar Del Ben

unread,
Jun 25, 2012, 11:21:53 AM6/25/12
to rubyonra...@googlegroups.com

-- 
Oscar Del Ben
Sent with Sparrow

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/jOkhN4UPzO8J.
To post to this group, send email to rubyonra...@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-ta...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

amruby

unread,
Jun 25, 2012, 11:26:45 AM6/25/12
to rubyonra...@googlegroups.com


On Monday, 25 June 2012 20:51:53 UTC+5:30, Oscar Del Ben wrote:



Thanks.....
that time @getquery.name gives the output

Cname  
-- 
Oscar Del Ben
Sent with Sparrow

On Monday, June 25, 2012 at 8:15 AM, amruby wrote:

i have one query, which gives the correct output in query browser.

    @getquery = Cname.select("cnames.name").where('skills.rate= ? AND skills.skill= ?',3,@searchstring).joins('JOIN skills ON cnames.id = skills.company_id')
   when i print the @getquery, it gives 

#<Cname:0x00000003f511f0>
#<Cname:0x00000003e8aa28> 

how to get the name from this @getquery?

Thanks

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/jOkhN4UPzO8J.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.

amruby

unread,
Jun 25, 2012, 11:46:20 AM6/25/12
to rubyonra...@googlegroups.com


On Monday, 25 June 2012 20:56:45 UTC+5:30, amruby wrote:


On Monday, 25 June 2012 20:51:53 UTC+5:30, Oscar Del Ben wrote:




Got the result 
Reply all
Reply to author
Forward
0 new messages