APM: DBI "bug"
wwalker at broadq.com
Sun Sep 14 20:16:37 CDT 2003
Given the following SQL:
SELECT b.ID, c.ID, c.ID
from Bugs as b, Clients as c, Projects as p
WHERE b.project = p.ID AND p.client = c.ID;
fetchall_arrayref() (or anything that uses fetchrow_arrayref()) works
fine, but I dislike using array references, and prefer hashrefs.
fetchrow_hashref returns only one result per row because all 3 fields
have different tables but the same column name.
Is there a switch in DBI to use table.column instead of just column when
building hashrefs? I couldn't find one....
www.broadq.com :) Bringing digital video and audio to the living room
More information about the Austin