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... -- Posted via http://www.ruby-forum.com/.
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 %><br />
<% end
end %>
-Jonathan.
On 5/15/06, joshua asem <ur_joshua@yahoo.com>
wrote:> 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...
>
>
> --
> Posted via http://www.ruby-forum.com/.
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
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... 2) 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........ -- Posted via http://www.ruby-forum.com/.