Changed transaction loading to use parameterised queries.