Lines Matching refs:dbh
45 my $dbh = $form->{dbh};
53 my $sth = $dbh->prepare($query);
78 $sth = $dbh->prepare($query);
91 $sth = $dbh->prepare($query);
96 $dbh->commit;
104 my $dbh = $form->{dbh};
161 $sth = $dbh->prepare($query);
165 $chart_id = $dbh->quote( $form->{id} );
175 $sth = $dbh->prepare($query);
192 my ($tax_id) = $dbh->selectrow_array($query);
199 $dbh->do($query) || $form->dberror($query);
210 $dbh->do($query) || $form->dberror($query);
215 my $rc = $dbh->commit;
225 my $dbh = $form->{dbh};
231 $sth = $dbh->prepare($query);
244 $sth = $dbh->prepare($query);
256 $sth = $dbh->prepare($query);
267 $sth = $dbh->prepare($query);
277 $sth = $dbh->prepare($query);
283 my $rc = $dbh->commit;
293 my $dbh = $form->{dbh};
300 $sth = $dbh->prepare($query);
308 $dbh->commit;
317 my $dbh = $form->{dbh};
325 $sth = $dbh->prepare($query);
339 $sth = $dbh->prepare($query);
349 $dbh->commit;
357 my $dbh = $form->{dbh};
384 $sth = $dbh->prepare($query);
387 $dbh->commit;
396 my $dbh = $form->{dbh};
403 $sth = $dbh->prepare($query);
406 $dbh->commit;
415 my $dbh = $form->{dbh};
423 $sth = $dbh->prepare($query);
431 $dbh->commit;
440 my $dbh = $form->{dbh};
448 $sth = $dbh->prepare($query);
459 $sth = $dbh->prepare($query);
470 $dbh->commit;
478 my $dbh = $form->{dbh};
499 $sth = $dbh->prepare($query);
502 $dbh->commit;
511 my $dbh = $form->{dbh};
517 $dbh->prepare($query)->execute( $form->{id} ) || $form->dberror($query);
518 $dbh->commit;
527 my $dbh = $form->{dbh};
534 $sth = $dbh->prepare($query);
542 $dbh->commit;
551 my $dbh = $form->{dbh};
559 $sth = $dbh->prepare($query);
572 $sth = $dbh->prepare($query);
582 $dbh->commit;
590 my $dbh = $form->{dbh};
611 $sth = $dbh->prepare($query);
613 $dbh->commit;
622 my $dbh = $form->{dbh};
628 $dbh->prepare($query)->execute( $form->{id} );
629 $dbh->commit;
638 my $dbh = $form->{dbh};
646 $sth = $dbh->prepare($query);
654 $dbh->commit;
663 my $dbh = $form->{dbh};
670 $sth = $dbh->prepare($query);
673 $dbh->commit;
682 my $dbh = $form->{dbh};
705 $dbh->prepare($query)->execute(@queryargs) || $form->dberror($query);
706 $dbh->commit;
714 my $dbh = $form->{dbh};
720 $dbh->prepare($query)->execute( $form->{id} ) || $form->dberror($query);
721 $dbh->commit;
730 my $dbh = $form->{dbh};
746 $sth = $dbh->prepare($query);
754 $dbh->commit;
763 my $dbh = $form->{dbh};
768 WHERE code = | . $dbh->quote( $form->{code} );
770 my $sth = $dbh->prepare($query);
777 $dbh->commit;
786 my $dbh = $form->{dbh};
812 $dbh->prepare($query)->execute(@queryargs) || $form->dberror($query);
813 $dbh->commit;
822 my $dbh = $form->{dbh};
828 $dbh->prepare($query)->execute( $form->{code} );
829 $dbh->commit;
838 my $dbh = $form->{dbh};
855 $sth = $dbh->prepare($query);
863 $dbh->commit;
872 my $dbh = $form->{dbh};
880 my $sth = $dbh->prepare($query);
888 $dbh->commit;
897 my $dbh = $form->{dbh};
924 $dbh->prepare($query)->execute(@queryargs) || $form->dberror($query);
925 $dbh->commit;
934 my $dbh = $form->{dbh};
938 WHERE code = | . $dbh->quote( $form->{code} );
940 $dbh->do($query) || $form->dberror($query);
941 $dbh->{dbh};
949 my $dbh = $form->{dbh};
953 my ($defaultcurrency) = $dbh->selectrow_array($query);
954 $defaultcurrency = $dbh->quote( $defaultcurrency =~ s/:.*//g );
1055 my $sth = $dbh->prepare($query);
1130 $dbh->commit;
1138 my $dbh = $form->{dbh};
1152 my $sth = $dbh->prepare($query);
1170 $sth = $dbh->prepare($query);
1187 $sth = $dbh->prepare($query);
1203 $dbh->commit;
1211 my $dbh = $form->{dbh};
1213 $id = $dbh->quote($id);
1219 my ( $nextdate, $repeat, $unit ) = $dbh->selectrow_array($query);
1221 $nextdate = $dbh->quote($nextdate);
1222 my $interval = $dbh->quote("$repeat $unit");
1230 my ($last_repeat) = $dbh->selectrow_array($query);
1240 $dbh->do($query) || $form->dberror($query);
1242 $dbh->commit;
1314 my $dbh = $form->{dbh};
1323 my $sth = $dbh->prepare($query);
1337 $dbh->prepare($query)->execute(@queryargs) || $form->dberror($query);
1347 $dbh->selectrow_array($query);
1350 $dbh->commit;
1386 my $dbh = $form->{dbh};
1389 $sth_plain = $dbh->prepare( "
1391 $sth_accno = $dbh->prepare(
1425 …my $sth_defcheck=$dbh->prepare("select count(*) from defaults where setting_key='$_';") || $form->…
1431 $dbh->do("update defaults set value=" . $dbh->quote($val) . " where setting_key='$_';");
1435 $dbh->do("insert into defaults(value,setting_key) values(" . $dbh->quote($val) . ",'$_');");
1441 my $rc = $dbh->commit;
1452 my $dbh = $form->{dbh};
1458 my $sth = $dbh->prepare($query);
1482 $sth = $dbh->prepare($query);
1516 $sth = $dbh->prepare($query);
1533 $dbh->commit;
1543 my $dbh = $form->{dbh};
1554 my $sth = $dbh->prepare($query);
1569 $sth = $dbh->prepare($query);
1578 $dbh->commit;
1587 my $dbh = $form->{dbh};
1590 $dbh->do($query) || $form->dberror($query);
1597 my $sth = $dbh->prepare($query);
1612 my $rc = $dbh->commit;
1685 my $dbh = $form->{dbh};
1696 $dbh->selectrow_array($query);
1698 $dbh->commit;
1706 my $dbh = $form->{dbh};
1710 my $sth = $dbh->prepare($query);
1711 my $sth_closedto = $dbh->prepare(qq|
1733 WHERE transdate < | . $dbh->quote( $form->{removeaudittrail} );
1735 $dbh->do($query) || $form->dberror($query);
1738 $dbh->commit;
1749 my $dbh = $form->{dbh};
1759 $sth = $dbh->prepare($query);
1768 $dbh->commit;
1776 my $dbh = $form->{dbh};
1788 $dbh->prepare($query)->execute( $uid, $form->{login} )
1796 my $sth = $dbh->prepare($query);
1813 $dbh->prepare($query)->execute(@queryargs) || $form->dberror($query);
1847 $dbh->prepare($query)->execute(@args)
1856 $dbh->prepare($query)->execute( $form->{id}, $form->{transdate} )
1867 $form->audittrail( $dbh, "", \%audittrail );
1870 my $rc = $dbh->commit;
1878 my $dbh = $form->{dbh};
1880 $sth = $dbh->prepare($query);
1887 $dbh->commit;