} if ('count' == $action) { $sql = "SELECT count(v.id) from defined_value v, attribute a\n\t\tWHERE v.attribute_id = a.id \n\t\tAND\ta.collection_id = {$c->id}\n\t\t"; $sth = $dbh->prepare($sql); $sth->execute(); $count = $sth->fetchColumn(); print "defined: {$count}\n"; } elseif ('delete' == $action) { print "defined values\n"; $sql = "SELECT v.id from defined_value v, attribute a\n\t\tWHERE v.attribute_id = a.id \n\t\tAND\ta.collection_id = {$c->id}\n\t\t"; $sth = $dbh->prepare($sql); $sth->execute(); while ($id = $sth->fetchColumn()) { $defined = new Dase_DBO_DefinedValue($db); if ($defined->load($id)) { $defined->delete(); print "deleted defined value\n"; } } } if ('count' == $action) { $sql = "SELECT count(id) from attribute a\n\t\tWHERE a.collection_id = {$c->id}\n\t\t"; $sth = $dbh->prepare($sql); $sth->execute(); $count = $sth->fetchColumn(); print "attributes: {$count}\n"; } elseif ('delete' == $action) { print "attributes\n"; $sql = "DELETE from attribute \n\t\tWHERE collection_id = {$c->id}\n\t\t"; $count = $dbh->exec($sql); print "deleted {$count} attributes\n";