ruby on rails - I want to show data from two tables in a single view -

-

i have 2 tables: 1 named um_org_data , other addresses.

the problem want show data um_org_data addresses addresses has foreign key um_org_datum_id.

here code of view in want show data 2 tables together:

<p id="notice"><%= notice %></p>   <div class="container">   <div class="row">       <div class="span3 pull-right">         <div class="well">           <h2>heading</h2>           <p>sample text</p>         </div>        </div>       <div class="span9">     <h2>organization details</h2>      <table class="table table-hover">       <tr>         <th col span="1" style="width: 200px">             </i>&nbsp;&nbsp;&nbsp;organization name:         </th>         <td><%= @um_org_datum.org_name %></td>       </tr>       <tr>         <th col span="1" style="width: 250px">             </i>&nbsp;&nbsp;&nbsp;organization description:         </th>         <td><%= @um_org_datum.org_description %></td>       </tr>       <tr>         <th col span="1" style="width: 250px">           </i>&nbsp;&nbsp;&nbsp;web domain:         </th>         <td><%= @um_org_datum.webdomain %></td>       </tr>       <tr>         <th col span="1" style="width: 200px">           <%= fields_for :address_attributes |p| %>             <%= p.label 'office address' %><br />                       </th>         <td><%= p.address.offc_addr %></td>         <% end %>       </tr>       <tr>         <th col span="1" style="width: 200px">             </i>&nbsp;&nbsp;office phone number:         </th>         <td><%= @um_org_datum.offc_ph %></td>       </tr>     </table>      <div class="control-group">       <div class="controls">               <a class="btn" href="/um_org_data" style="text-color:black">view all</a>          </div>     </div> </div> </div> </div>

i don't use join query in controller don't know how use join query. if problem needs join query, please tell me syntax , have change in view form show attributes of both tables.

table name: um_org_data , attributes: id, oeg_name, org_description, webdomain

table name: adrresses , attributes: id, offc_addr, um_org_datum_id

thanks in advance!

do have 1:n association? right?

definitely remove fields_for...you not in form!

change this:

  <tr>     <th col span="1" style="width: 200px">       <%= fields_for :address_attributes |p| %>         <%= p.label 'office address' %><br />                   </th>     <td><%= p.address.offc_addr %></td>     <% end %>   </tr>

to this:

  <tr>     <th col span="1" style="width: 200px">office address</th>     <%= @um_org_datum.addresses.each |p| %>      <td><%= p.office_addr %></td>     <% end %>   </tr>

check out markup, logic should clear now..


Comments

Post a Comment

Popular posts from this blog

java - JavaFX 2 slider labelFormatter not being used -

-
i have following code not label slider "foo50", etc... 1 expect setlabelformatter call, instead seems have no effect (the slider labelled 50, 100, etc , println's dont run). there missing? not implemented in default 2.2 skin? using oracle java 7 package javafxbugtest; import javafx.application.application; import javafx.scene.*; import javafx.scene.control.*; import javafx.stage.*; import javafx.util.stringconverter; public class javafxbugtest extends application { @override public void start(final stage primarystage) { slider cp = new slider(); cp.setlabelformatter(new stringconverter<double>() { @override public string tostring(double t) { system.out.println("nope?"); return "foo" + t.tostring(); } @override public double fromstring(string string) { system.out.println("he
Read more

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

-
the current version of mozilla firefox 23.0.1, version not support play mp3 shoutcast streams tcp port different 80 (most common 8000 shoutcast 1.9.8). i use flash when mp3 support not available in html5 audio, way detect is: try{ var = document.createelement('audio'); r = !!(a.canplaytype && !!a.canplaytype("audio/mpeg; codecs=mp3").replace(/^no$/,'')) }catch(e){ r = false; } the support mp3 shoutcast streams in firefox added in version 24 . a.canplaytype("audio/mpeg; codecs=mp3") = in chrome , firefox, chrome support, firefox not support, due current code detect not work firefox. the current version of jquery support ie 6 1.10.2, version not has .browser i think "stylized" way testing features , not querying browsers / versions, notwithstanding here see hard not violate "principle". what "stylized" way of detect mp3 icy support without navigator.useragent in firefox? ther
Read more

web - SVG not rendering properly in Firefox -

-
i have problem svg renderring in firefox. whilst works in safari, chrome or in ie, doesn't work in firefox. inspecting element seems layers there, background visible if it's z-index higher z-index of others. rendered in firefox: svg logo in firefox link original source file: svg file thanks help. ps: used sketch 3 export svg. if helps somehow. you're experiencing bug 995813 . i fixed bug time ago change still making way through release process example display correctly firefox 31 onwards released on 22 july 2014. in meantime if move fill="white" <mask> element child <use> element work around firefox bug.
Read more