### grabbing every column
    my $dbCommand = qq^select ^;
    foreach (@ticketsFields) {
        $dbCommand .= "$_,";
    }
    $dbCommand =~ s/,$//;

##</code><code>##

my $dbCommand = 'select '.join ',',@ticketsFields;

##</code><code>##

my @newArray = @{$rows};

##</code><code>##

 for(my $x = 0; $x < $ticketsFieldsSize; $x++)
            {
                ### assign the key and value in the hash
                $GenericData{$ticketsFields[$x]} = $newArray[$x];
            }
            

##</code><code>##

@GenericData{@ticketsFields} = @$rows;

##</code><code>##

\@ticketsRecords;
}