Hi, Thanks Jason. I'll try that.
Stay well, Barry On Monday, 28 April 2014 16:48:59 UTC+10, Jàπ (Jasper N. Brouwer) wrote: > > Hi Barry, > > You can specify if the foreign key used in an association should be > nullable or not: > > /** > * @ManyToOne(targetEntity="SportingTeam") > * @JoinColumn(name="team_id", referencedColumnName="id", > nullable=TRUE) > */ > private $sportingTeam; > > I'm not sure about the form, this is not something of Doctrine. > > PS: Doctrine itself doens't enforce properties to be "not null", but when > the database is in sync with your mapping data, and you have a NOT NULL > property, the database ofcourse will enforce this :) > > -- > Jasper N. Brouwer > (@jaspernbrouwer) > > > On 28 April 2014 at 06:23:56, Barry Steele > ([email protected]<javascript:>) > wrote: > > I have an applciation with a large number of tables, which is no real > issue. > > > > I do however have the following problem: > > > > Example > > > > > > InterestingPeople > > > > id : identifier > > sporting_team: team_id Null, (Nb Null values are perfectly reasonable = > > might have no sporting affiliations) > > > > ... other columns. > > > > > > sporting_team: > > > > id: identifier > > name > > > > Note. that the entries in the People table may have a sporting team, or > not. > > > > But if they do have a sporting team it must be in the Sporting Team > table. > > > > This is a perfectly reasonable RDBMS schema and is handled very nicely > in > > SQL, etc. > > > > I have tried to use "'DoctrineModule\Form\Element\ObjectSelect:" id > build > > a drop down select, which works as expected. > > > > But the Form will not validate as for some reason the form will not > accept > > a null in that field. > > > > I've seen a few posts about this but I would like to understand why this > > behaviour exists before committing any great effort to building the rest > of > > the DBAL . > > > > Does Doctrine try to enforce "NOT NULL" in this situation? > > > > If so, is there any reason? How do I overwrite it? > > > > Stay well, > > Barry > > > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
