I renamed the ID column to "id" and now instead of NULL I see value in the dev log for the update query. Not getting updated yet, but I think I will nail it down. Thanks for the help.
On Oct 19, 1:10 am, rvruby <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
