# Doubt in retrieving data to html?

**URL:** <https://www.ruby-forum.com/t/doubt-in-retrieving-data-to-html/173540>\
**Category:** Rails\
**Created:** [August 11, 2009, 6:30am UTC](https://www.ruby-forum.com/t/doubt-in-retrieving-data-to-html/173540 "2009-08-11T06:30:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![karthik](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/9fc348/32.png) [@karthik](https://www.ruby-forum.com/u/karthik)\
**Post date:** [August 11, 2009, 6:30am UTC](https://www.ruby-forum.com/t/doubt-in-retrieving-data-to-html/173540/1 "2009-08-11T06:30:26Z")

</div>

hi

I have a controller

def showagencies  
@getdata=Agency.all(:joins=\>:contracts,  
:select=\>“agencies.\*”,:conditions=\>[“contract\_id in (?) and  
agencies.status =?”,contracts.id,1 ])  
end

@getdata is not visible in html its lenght is o but has some contents

plz let me know how to access this

–  
Karthik.k  
Mobile - +91-9894991640

---

<div class="post-metadata">

**Author:** ![karthik](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/9fc348/32.png) [@karthik](https://www.ruby-forum.com/u/karthik)\
**Post date:** [August 11, 2009, 6:48am UTC](https://www.ruby-forum.com/t/doubt-in-retrieving-data-to-html/173540/2 "2009-08-11T06:48:14Z")

</div>

Karthik Kantharaj wrote:  
[…]

> @getdata is not visible in html its lenght is o but has some contents

Looks like @getdata contains an array. (And by the way, that’s a  
terrible variable name – use something more descriptive.)

> plz let me know how to access this

Iterate over the @getdata array and generate appropriate HTML for each  
element.

> –  
> Karthik.k  
> Mobile - +91-9894991640

## Best,

Marnen Laibow-Koser  
[http://www.marnen.org](http://www.marnen.org)  
removed\_email\_address@domain.invalid

---

<div class="post-metadata">

**Author:** ![karthik](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/9fc348/32.png) [@karthik](https://www.ruby-forum.com/u/karthik)\
**Post date:** [August 11, 2009, 6:53am UTC](https://www.ruby-forum.com/t/doubt-in-retrieving-data-to-html/173540/3 "2009-08-11T06:53:51Z")

</div>

On Tue, Aug 11, 2009 at 10:18 AM, Marnen Laibow-Koser \<  
removed\_email\_address@domain.invalid\> wrote:

> Iterate over the @getdata array and generate appropriate HTML for each  
> element…

Thank you  
i made small mistake  
but i got the output

–  
Karthik.k  
Mobile - +91-9894991640

---

<div class="post-metadata">

**Author:** ![karthik](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/9fc348/32.png) [@karthik](https://www.ruby-forum.com/u/karthik)\
**Post date:** [August 11, 2009, 7:03am UTC](https://www.ruby-forum.com/t/doubt-in-retrieving-data-to-html/173540/4 "2009-08-11T07:03:47Z")

</div>

On Tue, Aug 11, 2009 at 10:22 AM, karthik k [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> > Looks like @getdata contains an array. (And by the way, that’s a  
> > i made small mistake  
> > but i got the output
> 
> –  
> Karthik.k  
> Mobile - +91-9894991640

Hi i have another doubt

for the below code

def showagencies  
@contracts=Contract.find(:all,:conditions=\>[‘status=?’,1])

for contract in @contracts do

@agency=Agency.all(:joins=\>:contracts,  
:select=\>“agencies.\*”,:conditions=\>[“contract\_id in (?) and  
agencies.status =?”,contract.id [http://contracts.id/](http://contracts.id/),1 ])

```
  @contract_name=contract.name

  for getdata in @getdata do

    @agency_name=getdata.name

  end

```

end  
end

now as you can see @contract\_name will have many agencies

so i have another for loop and getting @agency\_name

so my out put will be

e.g

contract1  
agency1  
agency2  
contract2  
agency1  
agency2

now can i take @contract\_name and @agency\_name

and display like the above output in html

if my approach is wrong plz guide me

–  
Karthik.k  
Mobile - +91-9894991640