Thank You Fred for your reply.. I tried with the set_primary_key but
still it is throwing the exception,Sorry sending the code like that i
modified the code with removing the comments,the commented code is the
my trails to achieve the desired.I have given the ways and the errors
that are rendering for the particular call .. Please check and excuse
the mistakes if any,
> > Hi All,
> > I need to update the records in the mysql with the data
> > fields from the xml where the id field not presented in the database,
> > instead we took the number as primary key but not auto_incremented.
>
> > I treid with many attempts
> > for example my view as follows ..
>
> Your code is pretty impenetrable by virtue of the duplication, bits
> commented out etc... but if you don't have a primary key column you
> should be using set_primary_key to tell rails which column is the
> primary key
>
> Fred
>
> > <h1>Editing employee</h1>
> > <% form_tag :action =>'update',:id => @employee.number do -%>
> > <table>
> > <tr>
> > <td>
> > <%= label 'Employ_No','Employee Number' %>
> > </td>
> > <td>
> > <%= text_field 'employee','number',:value =>
> > @employee.number,:size => "16",:maxlength =>
> > "20",:id=>'number' %>
>
> > </td>
> > </tr>
> > <tr>
> > <td>
> > <%= label 'Employ_Name','Employee Name' %>
> > </td>
> > <td>
> > <%= text_field 'employee','name',:value =>
> > @employee.name,:size => "16",:maxlength =>
> > "20",:id=>"employ_name" %>
> > </td>
> > </tr>
> > <tr>
> > <td>
> > <%= label 'Employ_Job','Employee Job'
> > %>
> > </td>
> > <td>
> > <%= text_field 'employee','job',:value
> > =>
> > @employee.job,:size => "16",:maxlength =>
> > "20",:id=>"employ_job" %>
> > </td>
> > </tr>
> > <tr>
> > <td>
> > <%= label 'Employ_Salary','Employee
> > Salary' %>
> > </td>
> > <td>
> > <%= text_field
> > 'employee','salary',:value =>
> > @employee.salary,:size =>
> > "16",:maxlength =>
> > "20",:id=>"employ_salary" %>
> > </td>
> > </tr>
> > </table>
> > <%= submit_tag "Save" %>
> > <% end %>
>
> > I tried with text_field_tag but i found this is the right way since
> > we can access through the params[:employee] for all values and
> > params[:employee][:name] for individual fields
>
> > and in my controller
>
> > def update
> > begin
> > puts "In update"
> > no = params[:id]
> > employ = Employee.new
> > employ.number = params[:employee][:number]
> > employ.name = params[:employee][:name]
> > employ.job = params[:employee][:job]
> > employ.salary = params[:employee][:salary]
> >
>
> > employee = Employee.find(:first,:conditions => ["number = ?",no])
>
> > @emp = Employee.find(:first,:conditions => ["number = ?",no])
>
> > if @emp.update_attributes(params[:employee]) then
> > puts "success"
> > reder :text => "success"
> > else
> > puts "failed"
> > render :text => "failed"
> > end
>
> > rescue => e
> > puts "error is #{e}"
> > end
> > end
>
> > Where my model has only 4 fields name,number,job,salary (here number
> > is the primary key)
> > I tried with all the cases and vexed, It is throwing error for each case
> > as I tried are
>
> > @emp.update(:number,params[:employee]) for this the error i am getting as
> > # ERROR : The private method 'update' called
>
> > @emp.update_attributes(params[:employee]) for this the error is #
> > Mysql::Error:
> > #42S22Unknown column 'id' in 'where clause': UPDATE `employees` SET
> > `salary` = '20000', `number` = 6, `job` = 'se', `name` = 'xxx' WHERE
> > `id` = NULL
>
> > @emp.update_attributes(employ) for this i am getting the error as # ERROR
> > is undefined method
> > `stringify_keys!' for #<Employee>
>
> > How to achieve the updating? Please anybody help me..
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
