What do you mean selectall_arrayref is not cached?!?

my $res = $DBH->selectall_arrayref("
    SELECT employees.name, skills.name
    FROM employees,skills,employee_skills
    WHERE employees.id = ?
    AND skills.id = employee_skill.skill_id
",undef,$emp_id);
[download]

Correct me if i am wrong, but that statement is cached.

At any rate, please read (dkubb) Re: (2) Outputing data from mySQL query into format for use with HTML::Template if you are tired of building that hash data structure. :)

Jeff

R-R-R--R-R-R--R-R-R--R-R-R--R-R-R--
L-L--L-L--L-L--L-L--L-L--L-L--L-L--