From: raffir@...
Date: 2006-07-24T14:05:10+09:00
Subject: Bad query?

I have a find() query inside a for loop. Basically, I want the loop to
go through all elements in User.accounts and find all elements in
Accounts that have the same name as each element (to see other users
who have accounts with the same name).

Right now my code is as follows:

	<table>
	<%@session['user'].accounts.each do |i| %>
	<%Accounts.find(:all, :conditions => ["coursenumber LIKE ?",
"%#{i.coursenumber}%"]).each do |account| %>

	        <tr>
	        <td><%= account.coursename %></td>
	        <td><%= account.coursenumber %></td>
	        <td><%= account.user_id%></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>

This has the effect of outputting every single account in the Accounts
table. I'd like to restrict it to just outputting those accounts with
the same course name/number as each one of the User's.


Thanks a lot,

   - Raffi.