Thanks for your replies. Yes I might try to file it in trac, like you suggest, Cricket.
Euromark, yes my field is varchar NOT NULL and I don't think I have a bug because it is a pretty straight forward operation. Only when the field is blank, it seems to be ignored. If you don't have the problem, could you please post your bit of code? That would be much appreciated. On Oct 28, 6:48 pm, euromark <[email protected]> wrote: > must be a bug on your side > i can always empty my fields this way! > is your field set to varchar(x) NOT NULL? > > On 28 Okt., 05:40, cricket <[email protected]> wrote: > > > On Wed, Oct 27, 2010 at 8:00 PM, Caroline <[email protected]> wrote: > > > Hi, > > > I am trying to update a field to an empty string in my DB. Sounds > > > simple and I cannot find anybody else with the problem so I am > > > thinking I must be doing something really wrong... > > > > If I have a record in the DB with some value in 'description', for > > > example, and I do > > > > $data = array('id'=>1, 'name'=>'test', 'description'=>''); > > > $this->model->save($data); > > > > then the description will remain unchanged. I don't want to put 'NULL' > > > or any other thing in the field, just an empty string. > > > > Is it possible? What am I missing? > > > Thanks for any clue! > > > This has come up before. Apparently, it's a feature, not a bug. I > > can't remember if anyone ever explained why. I doubt it. You could > > file a bug and see if anyone deigns to explain the 'wontfix' that'll > > be dropped on it inside of 24 hours. > > > Personally, I prefer to set the field as NULL. If the column is > > defined as NOT NULL, then there's likely a good reason why some value > > must be present. I know--the empty is string != NULL, but anyway ... Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" 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/cake-php?hl=en
