Showing similar values in a table

[raffir]

I'm working on a project in which Accounts belong to a User.

I'd like the User's Welcome page to show who else has the same Accounts
(based on account name) as that user.

What I tried to do was place a SQL query inside a for loop, such that
the loop would go through the session User's accounts and check, in
turn, for all similarly named accounts in the Accounts table.

I think that there must be something wrong with my code; right now,
it's as follows:

<table>
<%@session['user'].accounts.each do |i| %>
<%Accounts.findall, conditions = ["coursename LIKE ?",
"%#{i.coursename}%"])%>
<tr>
<td><%= account.name %></td>
<td><%= account.number %></td>
<td><%= account.user_id%></td>
</tr>
</table>
<%end%>

<% end %>


I'm new to Ruby, so I think syntax is the most likely culprit here.

Thoughts?


Thanks a lot,

- Raffi.

 

[Jan Svitok]

Hi,

I'm working on a project in which Accounts belong to a User.
<table>
<%@session['user'].accounts.each do |i| %>
<%Accounts.findall, conditions = ["coursename LIKE ?",
"%#{i.coursename}%"])%>

You're missing second 'each' here
<%Accounts.findall, conditions = ["coursename LIKE ?",
"%#{i.coursename}%"]).each do |account| %>

 

[raffir]

Unfortunately, while it's now showing accounts, it's now showing every
single account. I'd just like it to show accounts with the same name as
the session user's.

Thanks,

- Raffi.

Hi,

I'm working on a project in which Accounts belong to a User.
<table>
<%@session['user'].accounts.each do |i| %>
<%Accounts.findall, conditions = ["coursename LIKE ?",
"%#{i.coursename}%"])%>

You're missing second 'each' here
<%Accounts.findall, conditions = ["coursename LIKE ?",
"%#{i.coursename}%"]).each do |account| %>

<tr>
<td><%= account.name %></td>
<td><%= account.number %></td>
<td><%= account.user_id%></td>
</tr>
</table>
<%end%>

<% end %>

 

[raffir]

Fixed it!

The line was missing a colon. I changed it to:

<%Accounts.findall, :conditions => ["coursename LIKE ?",
"%#{i.coursename}%"]).each do |account| %>


A question about the SQL query: how do I add another clause? For
example, what if I'd like to search by coursename (as above) and
coursenumber?

Thanks,

- Raffi.

 

[raffir]

Mysteriously stopped working again.

Code is as follows:

<h3><u>Who's in my courses?</u></h3>
<table>
<%@session['user'].accounts.each do |i| %>
<%Accounts.findall, :conditions => ["coursename LIKE ?",
"%#{i.coursename}%"]).each do |account| %>

<tr>
<td><%= account.coursename %></td>
<td><%= account.coursenumber %></td>
<td><%= account.first_name%> <%= account.last_name%></td>
<td><%= link_to 'Show', :controller=>'user', :action=>'userdetails',
:id=> account.user_id %></td>
</tr>

<%end%>
<% end %>
</table>