Retrieving hashes key & values (ASAP)

Hi,
I want to retrieve the set of key & values which returns from a
stored procedure : connection.select_all "exec common.dbo.scr_lookupric
‘AAP.N’ ".

The results i want to display in a view screen call result.rhtml.
Please help me out ASAP.

Thanks in advance.
joshua…

connection.select_all gives you an array of hashes which map
column_name => value. In the controller:

def view
@rows = ActiveRecord::Base.connection.select_all(“exec common …”)
end

And a very basic view.rhtml:

<% @rows.each do |row|
row.each do |key, value|
%>
<%= key %>: <%= value %>

<% end
end %>

-Jonathan.

Thanks a lot Jonathan… !!

I am able to access those key values properly now.
But one doubt is : Is there any way of accessing those values with the
key.

Something like: valuesOf(key1);

Now i am storing like this in one-one variable to refer further in the
view page. Pls suggest me as the following is little bit redundant.

===================================
<% @rows.each do |row|
row.each do |key, value| %>
<% if key==‘secid’ %>
<% @secid=value %><% end %>
<% if key==‘ric’ %><% @ric=value %> <% end %>
<% end
end %>

Thanks in advance…

  1. Also I have one issue for setting the table name : “CR_Country”

One issue is there in connecting one schema(table) “CR_Country” and
“CR_Security” from this sybase Db.

I have set false for pluralize_table_name and also setting the table
name explicitly too as follow in the “environment.rb” :

ActiveRecord::Base.pluralize_table_names = false

class CR_Country < ActiveRecord::Base
set_table_name “CR_Country”
end.

Now it gives an error as

not able to find object “select * from cR_Country”

and another one as :
not able to find object “select * from cr_security”

It somewhere converted the table name to small letters. Please help me
out if you have any suggestion.

Thanks in advance,
Joshua…

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs