summaryrefslogtreecommitdiff
path: root/LedgerSMB
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-03-21 00:31:26 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-03-21 00:31:26 +0000
commit7ad5ee49cf8d9f7bc60de5692fac8bed848210ac (patch)
tree6b03e73346a3ce02e7996890ec349fbea2cd00e9 /LedgerSMB
parent6a2b68a7a5ecd97a1e1ace6aaa5fdf7e9508028e (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
Diffstat (limited to 'LedgerSMB')
-rwxr-xr-xLedgerSMB/CP.pm8
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(