diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-03-21 00:31:26 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-03-21 00:31:26 +0000 |
| commit | 7ad5ee49cf8d9f7bc60de5692fac8bed848210ac (patch) | |
| tree | 6b03e73346a3ce02e7996890ec349fbea2cd00e9 | |
| parent | 6a2b68a7a5ecd97a1e1ace6aaa5fdf7e9508028e (diff) | |
fixing multiple database bind variable issues in CP.pm
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@966 4979c152-3d1c-0410-bac9-87ea11338e46
| -rwxr-xr-x | LedgerSMB/CP.pm | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/LedgerSMB/CP.pm b/LedgerSMB/CP.pm index 47e278a4..d95e716c 100755 --- a/LedgerSMB/CP.pm +++ b/LedgerSMB/CP.pm @@ -681,7 +681,7 @@ sub post_payments { FROM chart c JOIN acc_trans a ON (a.chart_id = c.id) WHERE $where - AND a.trans_id = $form->{"id_$i"}|; + AND a.trans_id = ?|; $sth = $dbh->prepare($query); $sth->execute($form->{"id_$i"}); @@ -790,9 +790,9 @@ sub post_payments { # update AR/AP transaction $query = qq| UPDATE $form->{arap} - SET paid = $amount, - datepaid = '$form->{datepaid}' - WHERE id = $form->{"id_$i"}|; + SET paid = ?, + datepaid = ? + WHERE id = ?|; $sth = $dbh->prepare($query); $sth->execute( |