Re: Interesting issue with create()

[prev] [thread] [next] [Date index for 2004/10/30]

On Sat, 30 Oct 2004 12:24:55 +0200, Jess Robinson
<castaway@xxxxxxxxxxxxx.x.xxxx.xx> wrote:

> Hi,
> I'm currently having problems with this. DB2's identity (generated by
> default as identity) fields seem to insist that in order to autogenerate a
> value, one just doesnt include this field at all, when using insert.
> But I don't see how to send that DEFAULT with CDBI either..

How about using a before_create trigger to set the value of the
primary column to 'DEFAULT'?

MyClass->add_trigger('before_create' => \&before_create);

sub before_create {
  my $self = shift;
  my $primary = $self->primary_column;
  $self->_attribute_set($primary, 'DEFAULT');
}

        -- 
        ----------------------------------------------------------------
 Drew Taylor                 *  Web development & consulting
 Email: drew@xxxxxxxxxx.xxx  *  Site implementation & hosting
 Web  : www.drewtaylor.com   *  perl/mod_perl/DBI/mysql/postgres
 ----------------------------------------------------------------