John: Off the top of my head these may be a couple options:
1. In your EO super class, override willInsert or awakeFromInsertion. The former assumes you’re extending ERXGenericRecord. Not so elegant but you could clobber every instance of a certain attribute type - with some overhead. 2. Possibly override MySQLExpression.formatValueForAttribute ? Force what you want when a certain attribute type is null. Maybe poll for the version of mysql there? Tim UCLA GSE&IS > On Nov 11, 2020, at 2:20 PM, John Pollard via Webobjects-dev > <webobjects-dev@lists.apple.com> wrote: > > Hi again list, > > My move to Catalina forced me to mysql 8. The previous version allowed NULL > to be passed to TIMESTAMP fields causing mysql to set them automatically, but > the NULL passed in the INSERT statements causes an error. > > From reading around I believe they should be passed as a blank “” rather than > NULL in order for mysql to default them. I should update my Wonder snapshot > as perhaps it is fixed in Wonder now, but I am wary of making too many > changes all at once. The lesson I suppose is to keep all aspects reasonably > up to date in good time! > > Is there a quick way to set all fields that are of type > dateTimeStampPrototype in the EOModel to be blank rather than NULL? Or I > could just set them to now in code, but is there one place I can do it rather > than in every entity class? > > Thanks > John > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com > > This email sent to li...@thetimmy.com _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
