[RDBO] catalyst calendar entry

2007-12-14 Thread Peter Karman
If you do not follow the Catalyst project, you might have missed this plug for the Rose projects: http://catalyst.perl.org/calendar/2007/7 -- Peter Karman . [EMAIL PROTECTED] . http://peknet.com/ - SF.Net email is spo

Re: [RDBO] good way to handle empty fields?

2007-12-14 Thread John Siracusa
On Dec 14, 2007 2:07 AM, Michael Lackhoff <[EMAIL PROTECTED]> wrote: > On 13.12.2007 14:03 John Siracusa wrote: > > On Dec 13, 2007 4:24 AM, Michael Lackhoff <[EMAIL PROTECTED]> wrote: > >> When I create a record with such a field, it is usually NULL but > >> after some editing with the help of RHT

Re: [RDBO] good way to handle empty fields?

2007-12-14 Thread Michael Lackhoff
On 14.12.2007 09:21 Darren Duncan wrote: > If you have a place that holds a value, it should always hold a > value. If you don't know a value for a place or a value isn't > applicable there, then the place shouldn't exist at all. > > The more correct way to do this which SQL supports is throug

Re: [RDBO] good way to handle empty fields?

2007-12-14 Thread Darren Duncan
At 9:44 AM +1100 12/14/07, Ron Savage wrote: >It is a good idea to declare all your base tables with NOT NULL >constraints on all columns whenever possible. >Maybe that's pointing you to the real problem. At 8:07 AM +0100 12/14/07, Michael Lackhoff wrote: >But I wouldn't count this as a bug. After