# Plz help to correct my query

**URL:** <https://www.ruby-forum.com/t/plz-help-to-correct-my-query/169003>\
**Category:** Rails\
**Created:** [May 28, 2009, 11:14am UTC](https://www.ruby-forum.com/t/plz-help-to-correct-my-query/169003 "2009-05-28T11:14:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![venkat\_ruby](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/4af34b/32.png) [@venkat\_ruby](https://www.ruby-forum.com/u/venkat_ruby)\
**Post date:** [May 28, 2009, 11:14am UTC](https://www.ruby-forum.com/t/plz-help-to-correct-my-query/169003/1 "2009-05-28T11:14:37Z")

</div>

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,

---

<div class="post-metadata">

**Author:** ![venkat\_ruby](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/4af34b/32.png) [@venkat\_ruby](https://www.ruby-forum.com/u/venkat_ruby)\
**Post date:** [May 28, 2009, 7:31pm UTC](https://www.ruby-forum.com/t/plz-help-to-correct-my-query/169003/2 "2009-05-28T19:31:49Z")

</div>

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](http://www.marnen.org)  
removed\_email\_address@domain.invalid

---

<div class="post-metadata">

**Author:** ![venkat\_ruby](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/4af34b/32.png) [@venkat\_ruby](https://www.ruby-forum.com/u/venkat_ruby)\
**Post date:** [May 28, 2009, 8:46pm UTC](https://www.ruby-forum.com/t/plz-help-to-correct-my-query/169003/3 "2009-05-28T20:46:31Z")

</div>

On May 28, 10:14 am, Venkat E. [removed\_email\_address@domain.invalid](mailto: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

---

<div class="post-metadata">

**Author:** ![venkat\_ruby](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/4af34b/32.png) [@venkat\_ruby](https://www.ruby-forum.com/u/venkat_ruby)\
**Post date:** [May 29, 2009, 6:32am UTC](https://www.ruby-forum.com/t/plz-help-to-correct-my-query/169003/4 "2009-05-29T06:32:15Z")

</div>

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](http://www.marnen.org)  
> removed\_email\_address@domain.invalid

Hi,  
user\_id is a field in timings table.