Plz help to correct my query

Rails
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 E. 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
[email protected]

3

On May 28, 10:14 am, Venkat E. [email protected]
wrote:

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 E. 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
[email protected]

Hi,
user_id is a field in timings table.