Hi,

I've defined a many-to-one relation between two tables A and B.
Can I specify the null value of a foreign key column. Usually this is 'null', but I need '0', i.e. if the foreign key column contains '0' the getter-method of A, which returns an object of type B, should return 'null'.

Thanks and best regards,
gerd

So long as there's no B object with id = 0, that's quite easy to do. Use the not-found="ignore" attribte of many-to-one to refer to that object.

You'll probably have to use the <sql-insert> and <sql-update> elements to correctly write that 0 value to the DB, though.