Is your primary key column not called id? If so you need to use
set_primary_key
Sent from my iPhone
On 18 Oct 2008, at 20:53, rvruby <[EMAIL PROTECTED]> wrote:
>
> I included the <%= f.text_field :id%> just to verify. Even after I
> removed it, it does not work.
>
> Please help.
>
> Processing LeavesController#update (for 127.0.0.1 at 2008-10-19
> 01:18:59) [POST]
> Session ID:
> BAh7CjoRZW1wc21ncmVtcGlkaQOQXwE6DGNzcmZfaWQiJTViZTdjMmU1ZDk1%
> 0AZWRlODc5OTM2YjMzMjdiNWRjNTc5OgplbXBpZCIKOTAyNjgiCmZsYXNoSUM6%
> 0AJ0FjdGlvbkNvbnRyb2xsZXI6OkZsYXNoOjpGbGFzaEhhc2h7AAY6CkB1c2Vk
> %0AewA6DG1ncm5hbWUiF2Jvc3NmbmFtZWJvc3NsbmFtZQ%3D
> %3D--1afd388b96433710a23047adc0f38b57c3422517
> Parameters: {"commit"=>"update",
> "authenticity_token"=>"949d78977aa51943832f36c2768c785f8d5bbbc7",
> "action"=>"update", "id"=>"4", "leaves"=>{"TO_DATE"=>"2008-12-31",
> "FROM_DATE"=>"2008-12-30", "LEAVE_TYPE"=>"compoff",
> "REASON_FOR_LEAVE"=>"Updated Reason for leave", "PHONE_NUMBER"=>"",
> "ADDRESS"=>""}, "controller"=>"leaves"}
> [4;36;1mLeave Columns (0.000000) [0m [0;1mSHOW FIELDS FROM
> `leaves` [0m
> [4;35;1mLeave Load (0.000000) [0m [0mSELECT * FROM `leaves`
> WHERE (`leaves`.`id` = '4') [0m
> [4;36;1mSQL (0.000000) [0m [0;1mBEGIN [0m
> [4;35;1mLeave Update (0.000000) [0m [0mUPDATE `leaves` SET
> `FROM_DATE` = '2008-12-30', `REASON_FOR_CANCELLATION` = NULL, `BACKUP`
> = NULL, `EMP_ID` = 90268, `TO_DATE` = '2008-12-31', `ADDRESS` = NULL,
> `MGR_EMP_ID` = 90000, `MANAGER_COMMENTS` = NULL, `REASON_FOR_LEAVE` =
> NULL, `LEAVE_TYPE` = 'compoff', `ID` = 4, `APPLIED_ON_DATE` =
> '2008-11-28', `PHONE_NUMBER` = NULL, `LEAVE_STATUS` = 'PENDING' WHERE
> `id` = NULL
>
> On Oct 18, 9:18 pm, Frederick Cheung <[EMAIL PROTECTED]>
> wrote:
>> On Oct 18, 5:15 pm, rvruby <[EMAIL PROTECTED]> wrote:> I am
>> trying to update a leave but the update does not work. Please let
>>> me know where I am making the mistake.(Looked in to the log, id in
>>> the
>>> update SQL statment shows NULL)
>>
>>> View
>>
>>> <h1>Editing Leaves</h1>
>>> <% form_for :leaves, @leaves, :url => { :controller =>
>>> "leaves", :action => "update" } do |f| %>
>>> <%= f.text_field :id%>
>>
>> That's really not a good idea. remove that text field.
>>
>> Fred
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
