Hmm.. a small example follows:
Code: Select all
my $SQL = "SELECT configitem.configitem_number, configitem.last_version_id FROM configitem where configitem.class_id = (select general_catalog.id from general_catalog where general_catalog.name = 'Access Rights (UserCard)')";
$Self->{DBObject}->Prepare( SQL => $SQL );
while ( my @Row = $Self->{DBObject}->FetchrowArray() ) {
my $ConfigItem = $Self->{ConfigItemObject}->ConfigItemGet(
ConfigItemID => $ConfigItemID,
);
}
if I replace ConfigItemGet with writing to log, then it loops all the entries in the result
Thanks in Advance!!!