This is very peculiar -- I don't know if it is AS-specific with MySQL or not, or, a version of MySQL I am using (I am using MySQL 5.0.27- community) If I create a table wit hthe following schema.....
CREATE TABLE `associates` ( `id` int(11) NOT NULL auto_increment, `username` varchar(16) NOT NULL default '', ... ... `tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id`), ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ; things in AS work swimmingly. However, if I add a column (anywhere in the table, here I am just putting at the end) that is a text type, call it `notes` (or even make, say varchar(500) ) as follows: CREATE TABLE `associates` ( `id` int(11) NOT NULL auto_increment, `username` varchar(16) NOT NULL default '', ... ... `tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `notes` text NOT NULL, PRIMARY KEY (`id`), ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ; When I go to do an edit on the table, regardless of whether I add any data to the notes field or not, and I save it, It won't come back up when I go to edit it again (I get a 500 error). It saves the values into the db correctly when I go directly into the db and look at the changes -- but it wont come back up in AS. I am using the latest version of Rails, Ruby and AS. Has anyone experienced anything like this trying to use a large text field in AS ? thank you, Janna B --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "ActiveScaffold : Ruby on Rails plugin" 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/activescaffold?hl=en -~----------~----~----~----~------~----~------~--~---
