Plz help to correct my query


#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
removed_email_address@domain.invalid


#3

On May 28, 10:14 am, Venkat E. removed_email_address@domain.invalid
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
removed_email_address@domain.invalid

Hi,
user_id is a field in timings table.