On Thu, Jul 23, 2009 at 4:48 PM, Peter Rabbitson <[email protected]<rabbit%[email protected]> > wrote:
> 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. > yeah, '? is a typo. Sorry about that. I'm not really sure what you don't understand about the above. I'll retype it without the placeholders I guess: INSERT INTO WorkScopeOperations ( > department, > description, > id, > signature_required, > work_order_id, > work_scope_id > ) SELECT > 'department foo', > 'description blah', > MAX(id) + 1, > 'mechanics sig required', > 1121, -- work_order_id > 2 -- work_scope_id > FROM WorkScopeOperations me > WHERE ( ( work_order_id = 1121 AND work_scope_id = 1 ) ) > Does that answer the question? -- fREW Schmidt http://blog.afoolishmanifesto.com
_______________________________________________ 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]
