Hello folks:

I'm using MySQL and have some tables where I can't use auto_increment on the primary keys (for some weird reason I won't bother to explain) and want to control the sequence of said primary keys manually.

Ex: a user submits a form having a couple of input fields and I receive them in a hash $r->{params} (yes - I'm using Maypole).

The piece of code that creates a new row in the database according to the form data looks something like this:

$r->{params}{$self->primary_columns} = &some_value;

$h = CGI::Untaint->new(%{$r->{params}});

$obj = $self->create_from_cgi($h);
[download]

Which to me, looks fine.

Apparently it's not.

Whenever this portion of code gets executed I receive the following error:

Can't insert new Library::Book: DBD::mysql::st execute failed: 
Column 'id' cannot be null [for Statement "INSERT INTO book (name, aut
+hor, id) VALUES (?, ?, ?)"]
at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/ContextualFetch.pm line 51, 
+<GEN2> line 7. 
at 
/usr/local/lib/perl5/site_perl/5.8.5/Class/DBI/FromCGI.pm line 246
[download]

I've searched and searched and can't seem to discover what exactly is causing the manually set primary key to be ignored.

Any suggestions or comments would be greatly appreciated. Thanks!