[Dbix-class] Call mysql stored procedure using Arbitrary SQL through a custom ResultSource

2009-10-19 Thread Arvind Singh
I created a stored procedure in mysql using CREATE PROCEDURE productpricing(in iskucode varchar(20)) BEGIN SET     @qty := 0 ; SELECT year_week, skucode, sold_this_week,     @qty := sold_this_week +     @qty as commulative     FROM (    SELECT date_format(str_to_date(DATE, '%b %d %Y'), '%Y-%v')

Re: [Dbix-class] create failures with has_one

2009-10-19 Thread Wallace Reis
On 15/10/2009, at 21:08, Dermot wrote: 2009/10/15 Wallace Reis wall...@reis.org.br: On 15/10/2009, at 08:34, Dermot wrote: 2009/10/15 Wallace Reis wall...@reis.org.br: On 14/10/2009, at 13:10, Dermot wrote: my $record = { 'validation_pass' = 1, 'files' = [], 'active'

Re: [Dbix-class] Call mysql stored procedure using Arbitrary SQL through a custom ResultSource

2009-10-19 Thread Mark Keating
Hi all on the Dbic list. The next technical meeting of North West England Perl Mongers will be held at the MEN offices in Manchester on the 28th October. We will be gifted with a talk by Jess Robinson on Docs and then Jess, Matt Trout and Kieren (three of the authors of the latest Catalyst

Re: [Dbix-class] create failures with has_one

2009-10-19 Thread Dermot
2009/10/19 Wallace Reis wall...@reis.org.br: On 15/10/2009, at 21:08, Dermot wrote: my $record = {       'validation_pass' = 1,       'files' = [],       'active' = 1,       'name' = 'Gustav MR',       'clipdata' = [                       {                         'contrib_id' = 2,      

[Dbix-class] Question the Book Authors

2009-10-19 Thread Mark Keating
The following message should have been sent with the above subject line, but, being a moron I replied to a message and didn't change the subject. My apologies. --- Hi all on the Dbic list. The next technical meeting of North West England Perl Mongers will be held at the

Re: [Dbix-class] create failures with has_one

2009-10-19 Thread Wallace Reis
On 19/10/2009, at 11:59, Dermot wrote: 2009/10/19 Wallace Reis wall...@reis.org.br: On 15/10/2009, at 21:08, Dermot wrote: my $record = { 'validation_pass' = 1, 'files' = [], 'active' = 1, 'name' = 'Gustav MR', 'clipdata' = [ {

Re: [Dbix-class] Question the Book Authors

2009-10-19 Thread Charlie Garrison
Good afternoon, On 19/10/09 at 4:18 PM +0100, Mark Keating m.keat...@shadowcat.co.uk wrote: The following message should have been sent with the above subject line, but, being a moron I replied to a message and didn't change the subject. My apologies. But that doesn't create a new thread;