[Maypole] AsForm again - selects?

Dave Howorth dhoworth@mrc-lmb.cam.ac.uk
Thu, 09 Dec 2004 16:47:38 +0000


I'm looking at the addnew form for a table that has a foreign key that 
is allowed to be null. AsForm has generated a select box for it, which 
is good (modulo the other issues we know about :)  But it's populated 
the select box with all the existing keys. There doesn't seem to be any 
way to say that I want a NULL value for this field in my new record.

I have SQL like this:

CREATE TABLE a_table (
   id  INT NOT NULL,
   fk  INT,
   FOREIGN KEY (fk) REFERENCES another_table (id)
) TYPE=InnoDB;

and code like this:

ATable->has_a( fk => 'AnotherTable' );
AnotherTable->might_have(entries => 'ATable', 'fk');

Is there something else I should be configuring or do I need to think 
about overriding AsForm?

maypole.perl.org seems to be down, so I couldn't check if 
<http://maypole.perl.org/?ImprovedAsForm> has anything new.

BTW, I'm frequently having trouble getting to perldoc.com over the past 
few weeks. Is this a shared problem? Are there mirrors?

Thanks, Dave