Rails - May 2006 - newbie q on displaying a db field value in the view

My layout calls a few links like so:

<%= link_to ''| Home '', :controller =>
''search'', :action => ''''%>
<%= link_to ''| Search '', :controller =>
''search'', :action => ''''%>

I would also like to display two values from my user table in the same 
layout right after the search:  the contents of the name field, and the 
contents of a integer field called tokens.

Can somebody please guide me or start me off in the correct direction 
please?

Thanks,
Vince

-- 
Posted via http://www.ruby-forum.com/.

Vince W. wrote:
> My layout calls a few links like so:
> 
> <%= link_to ''| Home '', :controller =>
''search'', :action => ''''%>
> <%= link_to ''| Search '', :controller =>
''search'', :action => ''''%>
> 
> I would also like to display two values from my user table in the same 
> layout right after the search:  the contents of the name field, and the 
> contents of a integer field called tokens.
> 
> Can somebody please guide me or start me off in the correct direction 
> please?
> 
> Thanks,
> Vince
I hihgly recommend you try some tutorials to get familiar with the rails 
basics.  Try some of the links here: 
http://www.digitalmediaminute.com/article/1816/top-ruby-on-rails-tutorials

But in answer to your question, you retrieve database rows as 
ActiveRecord object in your controller, then access the created 
variables in your view.

# app/controllers/users_controller.rb
class UsersController < ApplicationController
  def search
    @user = User.find(1) #find user with an id of "1"
  end
end

# app/views/users/search.rhtml
<p>Greetings <%= @user.name %>!</p>

-- 
Posted via http://www.ruby-forum.com/.

Vince W. wrote:
> My layout calls a few links like so:
> 
> <%= link_to ''| Home '', :controller =>
''search'', :action => ''''%>
> <%= link_to ''| Search '', :controller =>
''search'', :action => ''''%>
> 
> I would also like to display two values from my user table in the same 
> layout right after the search:  the contents of the name field, and the 
> contents of a integer field called tokens.
> 
> Can somebody please guide me or start me off in the correct direction 
> please?
> 
> Thanks,
> Vince
You''ll find this in those tutorials mentioned, but you''d have
a method
in your controller like:

@users = User.find(:all) - an instance variable (@user), that holds all 
(:all) of the rows from your User model.

then in your view:

<% for user in @users %>
<li><%=h user.name %></li> (name is one of the columns from
your
database)
<* end %>




-- 
Posted via http://www.ruby-forum.com/.