#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2003
    Posts
    174
    Rep Power
    12

    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. #2
  3. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,643
    Rep Power
    4247
    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

    "I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2003
    Posts
    174
    Rep Power
    12

    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!

IMN logo majestic logo threadwatch logo seochat tools logo