On Wed, Jul 22, 2009 at 09:30:19AM -0500, fREW Schmidt wrote: > > Indeed. The following works: > > > > INSERT INTO WorkScopeOperations ( > > department, > > description, > > id, > > signature_required, > > work_order_id, > > work_scope_id > > ) SELECT > > ? > > '?, > > MAX(id) + 1, > > ?, > > ?, > > ? > > FROM WorkScopeOperations me > > WHERE ( ( work_order_id = ? AND work_scope_id = ? ) ) > > >
I don't quite follow... What are the bind values that the top placeholders take? Also '?, seems to be a typo... I think. _______________________________________________ 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]
