From: Roy W P. <arc...@mt...> - 2008-04-18 15:54:30
|
On Friday 18 April 2008, Wallace Roberts Consulting wrote: > On Fri, Apr 18, 2008 at 7:41 AM, Roy W Pennington <arc...@mt...> wrote: > > On Friday 18 April 2008, Wallace Roberts Consulting wrote: > > > On Fri, Apr 18, 2008 at 7:11 AM, Roy W Pennington <arc...@mt...> wrote: > > > ... > > > > $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount, > > > > transdate, project_id, invoice_id) > > > > VALUES ($form->{id}, $ref->{chart_id}, $amount, > > > > '$form->{transdate}', $ref->{project_id}, $ref->{invoice_id})|; > > > > $dbh->do($query) || $form->dberror($query); > > > > > > >From the generated error, it appears that the following variables > > > might be undefined: > > > > > > $ref->{project_id}, $ref->{invoice_id} > > > > > > You could place a conditional in the perl code to check those > > > variables & use some kind of default value if they don't exist. > > > > So you're saying that SQL-ledger's official code is broken ? > > No. I'm saying that a pathological interaction has cropped up among > the new pieces of code, & making a very simple change to the above > SQL-Ledger code will ameliorate said pathology. I'm gonna get 1.49 dbd-pg via cpan and see if that helps. Gonna take the easiest route if possible. I'm not a real coder.. just a geek/user. "pathological interaction" brought a smile to my face... Hehe I had the same issue with a girlfriend many many years ago. I had just 'migrated' to a new GF and a "pathological interaction" developed. I found that the legacy version was more compatible and switching would have had an ameliorative effect. unfortunately there was no way to roll back the changes. Cheers ! Roy |