in my table ID is the primary key, what surprises me is, in the dev log there is a ID and id with values 4 and null
UPDATE `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 Thanks for your help. On Oct 19, 12:57 am, Frederick Cheung <[EMAIL PROTECTED]> wrote: > Is your primary key column not called id? If so you need to use > set_primary_key > > Sent from my iPhone > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
