I wrote: > That works but results in a series of SELECT followed by DELETE: > > SELECT me.sp_id, me.sp_status FROM sp me WHERE ( me.sp_id = ? ): '600011' > DELETE FROM species WHERE ( sp_id = ? ): '600011'
Just to be clear. The same pair of queries results from the following code: $sp_rs->find($id)->delete; > The SELECTs are completely redundant. Is there any way in DBIC to delete > a row from a table given the primary key other than retrieving a full > object to invoke delete on? _______________________________________________ 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]
