my $sth = $dbh->prepare($query);
$sth->execute();
-
$query = "DELETE FROM authorised_values WHERE category = 'ITEMTYPECAT'";
$sth = $dbh->prepare($query);
$sth->execute();
$sth = $dbh->prepare($query);
$sth->execute();
+ $query = "DELETE FROM itemtypes WHERE 1 = 1";
+ $sth = $dbh->prepare($query);
+ $sth->execute();
+
foreach my $node ($dom->findnodes('/document/authorised_values/value')) {
my $category = sql_str($node->findvalue('./category'));
my $authvalue = sql_str($node->findvalue('./authvalue'));