untuk app/models/kamar.rb
kayaknya mesti sedikit dirubah menjadi:
class Kamar < ActiveRecord: :Base
belongs_to :class_name => "Hotel",
:foreign_key => "id_hotel"
end
karena secara default foreign key untuk tabel kamar adalah hotel_id, sehingga
perlu kita override menjadi id_hotel
def show
@kamar = Kamar.find(params[:id])
end
di show.rhtml kita pake
kamar id : <%= @kamar.id %> <br/>
hotel id: <%= @kamar.hotel.id %>
mungkin begitu, tapi saya belum coba ya..
----- Original Message ----
From: secreet admirer <[EMAIL PROTECTED]>
To: id-ruby@yahoogroups.com
Sent: Tuesday, October 23, 2007 1:28:32 PM
Subject: [id-ruby] [Tanya] Tampilkan Data Di Tabel Lain
Saya bingung, mohon bantuan. Saya mo tampilkan data yang ada di
tabel lain yang terelasi antar tabel. Berikut Keterangannya :
------------ --------- --------- --------- --------- --------- -
Location : app/models/kamar. rb
------------ --------- --------- --------- --------- --------- -
class Kamar < ActiveRecord: :Base
belongs_to :hotel
...
def self.find_all_ in_kamar( hotel)
hotel = Hotel.find_by_ name(hotel)
self.find :all, :conditions => "id_hotel = #{Hotel.id}"
end
...
------------ --------- --------- --------- --------- --------- -
Location : db/migrate/kamar. rb
------------ --------- --------- --------- --------- --------- -
class CreateKamars < ActiveRecord: :Migration
def self.up
create_table :kamars do |t|
t.column :id_hotel, :string, :limit => 8
...
end
execute 'ALTER TABLE kamars ADD CONSTRAINT fk_kamars_hotels
FOREIGN KEY ( id_hotel ) REFERENCES hotels( id ) ON DELETE CASCADE'
...
end
------------ --------- --------- --------- --------- --------- -
Gimana caranya supaya supaya di view/kamar/show. rhtml saya bisa menampilkan
informasi semua data hotel yang memiliki id hotel sesuai dengan id_hotel pada
tabel kamar. Apa yang harus saya tulis di :
class KamarController < ApplicationControll er
....
def show
@kamar = Kamar.find(params[ :id])
?? Apa yang harus saya tulis disini utk menampilkan data hotel??
end
....
Saya sudah coba ini dan berikut pesan pesan error mereka (T_T)
------------ --------- --------- -----
Experimen pertama
------------ --------- --------- ----
def show
@kamar = Kamar.find(params[ :id])
@hotel = Hotel.find(: all, :conditions => "id = '[EMAIL PROTECTED]'" )
end
------------ --------- --------- --------- -----
Experimen pertama && Error
------------ --------- --------- --------- -----
NoMethodError in KamarController# show
You have a nil object when you didn't expect it!
The error occurred while evaluating nil.id_hotel
Hiks.. banyak experimennya sampe takut kepanjangan. .. PLEASE ID-RUBY PIMP MY
CODING. sekalian kalo boleh sama coding buat show.rhtml nya.
[-o< Pleaseeee... Thanks for
------------ --------- --------- ---
Bergabunglah dengan orang-orang yang berwawasan, di bidang Anda di Yahoo!
Answers
[Non-text portions of this message have been removed]
<!--
#ygrp-mkp{
border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;}
#ygrp-mkp hr{
border:1px solid #d8d8d8;}
#ygrp-mkp #hd{
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;}
#ygrp-mkp #ads{
margin-bottom:10px;}
#ygrp-mkp .ad{
padding:0 0;}
#ygrp-mkp .ad a{
color:#0000ff;text-decoration:none;}
-->
<!--
#ygrp-sponsor #ygrp-lc{
font-family:Arial;}
#ygrp-sponsor #ygrp-lc #hd{
margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
#ygrp-sponsor #ygrp-lc .ad{
margin-bottom:10px;padding:0 0;}
-->
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean,
sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a{
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc{
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o{font-size:0;}
.MsoNormal{
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq{margin:4;}
-->
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
