plz help to correct my query

rubyonrails-talk
1

Hi,

I want to display both terminal_id and user_id. If i try to echo by using p i.e p @list It is displaying only terminal_id. Please help me to correct my query.

@list = NetworkTerminal.find(:all, :select => "network_terminals.terminal_id,timings.user_id", :joins => "LEFT JOIN timings ON network_terminals.terminal_id = timings.terminal_id", :conditions => {:network_id => 'net343'} )

Thanks,

2

Venkat Eee wrote:

Hi,

I want to display both terminal_id and user_id.

[...]

Where is user_id supposed to come from? It's not clear from looking at your query.

Best,

3

Hi,

I want to display both terminal_id and user_id. If i try to echo by using p i.e p @list It is displaying only terminal_id. Please help me to correct my query.

You're going to have to do that your self - output foo.user_id and foo.terminal_id for each foo in your list.

Fred

4

Marnen Laibow-Koser wrote:

Venkat Eee wrote:

Hi,

I want to display both terminal_id and user_id.

[...]

Where is user_id supposed to come from? It's not clear from looking at your query.

Best, -- Marnen Laibow-Koser http://www.marnen.org marnen@marnen.org

Hi, user_id is a field in timings table.