Faschingskostüm
für fasching
karneval fasching

def create  
@task = Task.new(params[:task])  
@project = Project.new(params[:project], @task) 
if @project.save    
redirect_to :action => 'index'  
else    
render :action => 'new'  
end
end

or stick with the same approach but inside the Project class have a tasks method that returns a new instance of Tasks that contains a build method.  Thoughts?

Thanks in advance.

Here's my SO posting for this question:
http://stackoverflow.com/questions/9236 … new-object

I have two models, Story and Category. Using the form for Story#new, I'd like to be able to save the foreign key for Category.

To display the selection data from Category on the Story#new form page I've used:

<%= collection_select(:category , :category, Category.all , :id, :category, {:prompt => 'Select Category...'}) %>

How can I save category_id to the newly created Story object?Story has attributes: industry_id and user_id, Category has attribute name development.log tells me this: (it looks like it's trying to add a new category (99) to the Categories table:

Started POST "/stories" for 127.0.0.1 at 2012-02-10 17:32:56 -0600
 Processing by StoriesController#create as HTML
story"=>{"industry_id"=>"8", "user_id"=>"8"}, "category"=>{"category"=>"99"}, "commit"=>"Create Story"}

Can u provide me some more functionalities like Update and delete operations of multiple tables (models) through single form.

If we are able to perform these operations then only our article should be perfect right...!!

I looking for your reply.

I have 2 tables. Lesson and Tag. A lesson can have multiple tags. When I save, records are saving in both tables but the tag.body is saving as NULL. What am I doing wrong?

This is lesson,rb
class Lesson < ActiveRecord::Base
#Mandatory fields validation
validates_presence_of :title, :contact_yn
has_many :tags
end

This is tag.rb
class Tag < ActiveRecord::Base
    belongs_to :lesson
end

My lesson.new is
<h1>New lesson</h1>

<%= error_messages_for :lesson %>
<%= error_messages_for :tag %>

<% form_for(@lesson) do |f| %>
  <p>
    <%= f.label :title %><br />
    <%= f.text_field :title %>
  </p>
  <p>
    <%= f.label :description %><br />
    <%= f.text_area :description %>
  </p>

  <p>
    Can others contact you?<br />
   <%= f.select :contact_yn, ['Yes', 'No'] %>
  </p>
<% fields_for :tags do |i| %>
      <p>
        Tags:<br />
    <%= i.text_field :body %>
</p>
<% end %>
  <p>
    <%= f.submit 'Save' %>
  </p>

<% end %>
<%= link_to 'Back', lessons_path %>

My lesson controller is
def new
    @lesson = Lesson.new
    @tag = Tag.new
   
    respond_to do |format|
      format.html # new.html.erb
      format.xml  { render :xml => @lesson }
    end
  end

  # GET /lessons/1/edit
  def edit
    @lesson = Lesson.find(params[:id])
  end

  # POST /lessons
  # POST /lessons.xml
  def create
    @lesson = Lesson.new(params[:lesson])
    $tag = @lesson.tags.build(params[:tag])

    respond_to do |format|
      if @lesson.save
        flash[:notice] = 'Lesson was successfully created.'
        format.html { redirect_to(@lesson) }
        format.xml  { render :xml => @lesson, :status => :created, :location => @lesson }
      else
        format.html { render :action => "new" }
        format.xml  { render :xml => @lesson.errors, :status => :unprocessable_entity }
      end
    end
  end

When I save, records are saving in both tables but the tag.body is saving as NULL. What am I doing wrong?

TIA
-vas

class Event < ActiveRecord::Base
  set_table_name "er_event"
  set_sequence_name "er_event_seqno"
  set_primary_key :eventid
  has_many :product
end

class Product < ActiveRecord::Base
  set_table_name "er_product"
  set_primary_key :productid
  belongs_to :event, :class_name => "Event", :foreign_key => [:eventid]
end

class CreateController < ApplicationController
  def create
    @event = Event.new(params[:er_event])
    @product = @event.product.build(params[:product])
    if @event.save
      flash[:notice] = 'New promotion is created.'
    else
      flash[:error] = 'Please correct the errors below:'
    end
    render :action => "index"
  
  end
end

 select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT er_product.productid FROM er_product WHERE (er_product.productid = 'P1' AND er_product.eventid IS NULL) ) raw_sql_ where rownum <= 1) where raw_rnum_ > 0
  Event Exists (2.2ms)   select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT er_event.eventid FROM er_event WHERE (er_event.title = 'test') ) raw_sql_ where rownum <= 1) where raw_rnum_ > 0
Rendering template within layouts/application

Now i have removed the use has_many:through association.
And i could able to upload stream into database.

But the problem here is:
while uploading data into other tables
1)i am not getting the transportstream_id from transportstreams in to the programs table.
2)throughing the error like:
ActiveRecord::StatementInvalid in Containerformats#show
Showing app/views/containerformats/show.html.erb where line #26 raised:

Mysql::Error: Unknown column 'programs.containerformat_id' in 'where clause': SELECT * FROM `programs` WHERE (`programs`.containerformat_id = 2)

but data is storing in the correspomding tables.

my code details;

in containerformatcontroller:
def new
    @containerformat = Containerformat.new
    @containerformat.transport_streams.build
     @containerformat.programs.build
     @containerformat.streams.build

    respond_to do |format|
      format.html # new.html.erb
      format.xml  { render :xml => @containerformat }
    end
  end

--------in containerformat model
class Containerformat < ActiveRecord::Base
has_many :transport_streams
has_many :programs
has_many :streams

def transport_stream_attributes=(transport_stream_attributes)
transport_stream_attributes.each do |attributes|
transport_streams.build(attributes)
end
end

def program_attributes=(program_attributes)
program_attributes.each do |attributes|
programs.build(attributes)
end
end
def stream_attributes=(stream_attributes)
stream_attributes.each do |attributes|
streams.build(attributes)
end
end

end
---------------------in views(new.html.erb)<h1>New containerformat</h1>

<% form_for(@containerformat) do |f| %>
  <%= f.error_messages %>

  <p>
    <%= f.label :stream_name %><br />
    <%= f.text_field :stream_name %>
  </p>
  <p>
    <%= f.label :location %><br />
    <%= f.text_field :location %>
  </p>
  <p>
    <%= f.label :containertype_id %><br />
    <%= f.text_field :containertype_id %>
  </p>
 
  <%for transport_stream in @containerformat.transport_streams%>
     <%fields_for "containerformat[transport_stream_attributes][]", transport_stream do |ts_form|%>
     <p>Num_programs</p>
     <p><%= ts_form.text_field :num_programs%></p>
     <p>Encryption std</p>
     <p><%= ts_form.text_field :encryption_std%></p>
     <% end %>
     <% end %>

 
    <%for program in @containerformat.programs%>
       <%fields_for "containerformat[program_attributes][]", program do |ts_form|%>
       <p>PID</p>
       <p><%= ts_form.text_field :pid%></p>
       
       <% end %>
       <% end %>
       
       
       <%for stream in @containerformat.streams%>
              <%fields_for "containerformat[stream_attributes][]", stream do |ts_form|%>
              <p>videocodecid</p>
              <p><%= ts_form.text_field :videoCodec_id%></p>
              <p>audiocodecid</p>
              <p><%= ts_form.text_field :audioCodec_id%></p>
             
              <% end %>
              <% end %>
 
 
  <p>
 
    <%= f.submit "Create" %>
  </p>
<% end %>

<%= link_to 'Back', containerformats_path %>
-------showpage
<p>
  <b>Stream name:</b>
  <%=h @containerformat.stream_name %>
</p>

<p>
  <b>Location:</b>
  <%=h @containerformat.location %>
</p>

<p>
  <b>containertype_id:</b>
  <%=h @containerformat.containertype_id %>
</p>

<%- @containerformat.transport_streams.each do |task| -%>
<p>
    <b>Number of programs:</b>
    <%= task.num_programs %>
</p>
<%- end -%>

<%- @containerformat.programs.each do |task| -%>
<p>
    <b>PID:</b>
    <%= task.pid %>
</p>
<%- end -%>

<%- @containerformat.streams.each do |task| -%>
<p>
    <b>videoCodec_id:</b>
    <%= task.videoCodec_id %>
   
    <b>audiocodecid:</b>
    <%= task.audioCodec_id %>
    </p>
<%- end -%>

<%= link_to 'Edit', edit_containerformat_path(@containerformat) %> |
<%= link_to 'Back', containerformats_path %>

Can you tell me where i am doing the mistake?
Can you suggest me how to get the valus of other tables in the show page?

regards
Srikanth

- do you work with an existing DD schema or you should create one yourself?
- you tell

In this case I'd see you models like that

class containerformat < AR
  has_many :transportstreams
end
class transportstream < AR
  belongs_to:containerformat 
  has_many :programs
end
class program < AR
  belongs_to:transportstream 
  has_many :streams
end

That's why I suppose that you have a work flow like that:

containerformat -> has many -> transportstreams -> has many -> programs -> has many -> streams.
If it's the case no need to use has_many :through association. Use it only if something has many 'through something' like for example transportstream has many streams through programs. In this case you program table should have a reference as transportstream_id to the corresponding transportstream.

this the data of stream to be uploaded in to database.

For this i have below tables :
containerformats:to store the name of stream and location
----------------

trasportstreams:has below fields
----------------
"num_programs"
"encryption_std"
"containerformat_id"

programs table: has below fields
----------------
"pid"
"closedcaption"
"privatedata_pid"
"transport_stream_id"
"numAudio"
"numVideo"

streams table:has below fields
-----------
"videoCodec_id"
"resolution"
"audioSamplingRate"

And i am using ryans complexforms post to upload data into models.

--Can you suggest me to provide the association between the models.
i could not able to proceede from this step.
Any help is greatly appreciated.

thanks
Srikanth