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/.