SOLVED. Due to my tunnel vision on the statement and missing the incorrect 'and', I see now the answer is. --- execute "UPDATE designs SET name = 'Liquid', file_name ='liquid' WHERE id = '3'" ---
It seems that I would have gotten an error on any of my incorrect statements, but none were returned. Oh well. On Feb 13, 10:08 am, yachtman <[email protected]> wrote: > Here is probably a simple question for most of you, where I can't seem > to update records in sqlite3 through a migration. Any suggestions > would be most appreciated.... > > With this code, nothing happens: > ------ > class AlterDataInDesigns < ActiveRecord::Migration > def self.up > execute "UPDATE designs SET name = 'Liquid' and file_name = > 'liquid' WHERE id = '3'" > end > ... > end > ------ > > With this code, it changes the name to '0'??? (the difference is the > ';' added to the end) > ------ > class AlterDataInDesigns < ActiveRecord::Migration > def self.up > execute "UPDATE designs SET name = 'Liquid' and file_name = > 'liquid' WHERE id = '3';" > end > ... > end > ----- --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
