Beefy Boxes and Bandwidth Generously Provided by pair Networks
Bob Perl: the Markov chain saw  Problem creating a row with a
manually specified primary key via CDBI::FromCGI  by Booger
(Pilgrim) on Oct 09, 2004 at 19:44 UTC
( #397897=perlquestion: print w/ replies, xml ) Need Help??
Booger has asked for the wisdom of the Perl Monks concerning the
following question:  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);  Which to me, looks fine.
Apparently it's not.  Whenever this port