projekt kivitendo

        $query =

          qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, fx_transaction, cleared, project_id, taxkey, tax_id, chart_link) | .

          qq|VALUES (?, (SELECT id FROM chart WHERE accno = ?), ?, ?, 't', 'f', ?, | .

          qq|        (SELECT tax_id| .

          qq|         FROM taxkeys| .

          qq|         WHERE chart_id= (SELECT id | .

}

1;