|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
December 16th, 2006, 03:36 PM
|
|||
|
|||
|
Help w/ pulling data from 2 tables and displaying the results
Hello,
I'm brand new to ruby and I'm having trouble pulling data from one table (table_1), looping through the results and pulling data from another table (table_2) and displaying the results of table_2 in one field. the pseudo code would be as follows: Code:
result_1 = select first_name from table_1
loop results_1
{
puts "<tr><td> results_1.first_name<td>"
results_2 = select table_2.info from table_2 where table_1.user_id = table_2.user_id;
puts "<td>"
loop results_2
{
puts "<li>table_2.info
}
puts "</td>"
}
The display would look like this for 1 row: joe | -info 1 -info 2 -info 3 Help - I'm desparate! clem_c_rock is online now Report Post Edit/Delete Message Last edited by CLEM_C_ROCK : December 17th, 2006 at 04:13 PM.
|
|
#2
December 17th, 2006, 02:39 PM
|
||||
|
||||
|
Umm, you could revise your select statement to this:
Code:
select table1.first_name, table_2.info from table_2 where table_1.user_id = table_2.user_id; This way, you need only one loop and the data is in the tabular format you need.
__________________
Up the Irons What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home. "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest Down with Sharon Osbourne Puzzle of the Month solved by sizeablegrin, etienne141 and L7Sqr, superior C/C++ programmers of the month
|
|
#3
December 19th, 2006, 12:59 PM
|
|||
|
|||
|
Problem solved!
Ok - I finally buckled down and asked a couple of questions and there
was a method in the accounts model that was killing this whole concept: Problem solved! The project I'm building a little addition to is huge and extremely complex so there's a lot of code that could overide or clash w/ code I'm trying to develop. That was the case here. In the Account model there was this method that was overiding my join attempts. def spaces spaces = Space.find :all, :conditions => ['owner_id = ?', self.user_id] end Now, once I got rid of that method - this works perfectly! @accounts = Account.find(:all, :include => :spaces, :limit => 20) I got dumped right into the fire w/ this new project - it pays to ask a few simple questions. I tore a lot of hair out trying to figure it out, but also learned a great deal trying to find the answer. posts! Cheers!
|
|
| Viewing: Dev Shed Forums > Programming Languages > Ruby Programming > Help w/ pulling data from 2 tables and displaying the results |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
