Using Variables after Find

Rails
1

Hello,
I am still new to RoR and I’m having a very basic problem… Ok, so I
can display all the results of two different tables by calling (in my
case)

@bes = Bes.find(:all)
@prov = Import.find(:all)

This works great, however, I need to take information from both of these
and put them in a new variable to display (multi-row). How am I to do
this? I tried to use stuff like @newrow = Bes.bes_phonenumber , etc…
but I am not having any luck. Can anybody show me how to do this
properly?

Thank you all very much,

  • Jeff M.
2

@bes and @prov should now contain all the data you need for your
views.

In your views, you would then get the data out with:

<% @bes.each do |x| %>
<%= x.the_name_of_one_of_your_tables_here %>
<% end %>

or

<% @prov.each do |x| %>
<%= x.the_name_of_one_of_your_tables_here %>
<% end %>

try that

jackster.mobi

On Jan 22, 4:05 pm, Jeff M. [email protected]

3

Jeff M. wrote:

Hello,
I am still new to RoR and I’m having a very basic problem… Ok, so I
can display all the results of two different tables by calling (in my
case)

@bes = Bes.find(:all)
@prov = Import.find(:all)

This works great, however, I need to take information from both of these
and put them in a new variable to display (multi-row). How am I to do
this? I tried to use stuff like @newrow = Bes.bes_phonenumber , etc…
but I am not having any luck. Can anybody show me how to do this
properly?

Thank you all very much,

  • Jeff M.

erm…as “find” returns an array you have to access each element in that
array one by one…so you’d do @bes[0].bes_phone_number then
@bes[1].bes_phone_number…

or:

@bes.each do |i|
@bes[i].bes_phonenumber
end

though i’m a noob too so there’s probably a better way of doing this…?

do you know about the ruby console where you can test out bits of code
like this? run ruby script/console and you can play around with
variable assignments and what not

4

Jeff M. wrote:

sweet, thanks guys! I have another question, though… If all of this is
being done in the view, then if I have to make changes to some of the
variables, I have to that in the view too, right? I used this line to
change the string length in the view:

<%= bes.bes_phonenumber if bes.bes_phonenumber.size==11
bes.bes_phonenumber=string[1…11] %>

It is supposed to cut off the first digit of the phone number if the
length of the number is 11 characters long. However, this doesn’t work
(compile error). Can somebody clarify this for me?

I appreciate everyone’s help, thank you!

  • Jeff M.
    you mean you want to say: if the phonenumber’s size is 11 cut the first
    digit from it right?

i’d say:

<%if bes.bes_phonenumber.to_s.size == 11%>
<%bes.bes_phonenumber = bes.bes_phonenumber.to_s.slice(1…11)%>
<%bes.bes_phonenumber.to_i%>

so here in line 1 you get the string size of bes_phonenumber then in
line 2take off the leading digit and store the result in
bes_phonenumber…but then bes_phonenumber is a string so the last line
converts it back to an int

this is without doubt NOT the best way of doing this (in fact it’s
probably the worst), but it works…

5

sweet, thanks guys! I have another question, though… If all of this is
being done in the view, then if I have to make changes to some of the
variables, I have to that in the view too, right? I used this line to
change the string length in the view:

<%= bes.bes_phonenumber if bes.bes_phonenumber.size==11
bes.bes_phonenumber=string[1…11] %>

It is supposed to cut off the first digit of the phone number if the
length of the number is 11 characters long. However, this doesn’t work
(compile error). Can somebody clarify this for me?

I appreciate everyone’s help, thank you!

  • Jeff M.
6

That works! Thank you for you help! You guys here at Ruby-Forum know
what you’re talking about!