Hello everyone,

Is there any way (without transactions or 2 DB trips) to achieve the following:

Insert a row and use the autoincremented primary key value in another column.

table: pictures
id integer primary key,
filename varchar2(128)

my $picture = $c->model('myDB::Pictures')->new_result({
                                           filename => <ID> . '_' . $filename
                                });

thanks in advance

david

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]

Reply via email to