SQL query

[jj99]

Hi I follow the OTRS developer manual for using sql queries inside the modules.

I run the following query but I only get first value from result.

Code: Select all

my $SQL = "SELECT id FROM roles ";

$Self->{DBObject}->Prepare(SQL => $SQL, Limit => 15);

my @Row = $Self->{DBObject}->FetchrowArray();
    

if I check the size of @Row array I get one but in reality I have many roles created in roles table.

Can some one tell me whats missing ?

[reneeb]

You have to fetch the roles in a loop:

Code: Select all

my $SQL = "SELECT id FROM roles ";

$Self->{DBObject}->Prepare(SQL => $SQL, Limit => 15);

my @RoleIDs;
while ( my @Row = $Self->{DBObject}->FetchrowArray() ) {
    push @RoleIDs, $Row[0];
}

[jj99]

thank u . I realized my error. yes u are right.