On Thu, Mar 26, 2009 at 10:48, David Schmidt <[email protected]> wrote: > 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 > });
If you weren't using DBIC, how would you solve this? -- Thanks, Rob Kinyon _______________________________________________ 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]
