APM: DBI "bug"

Wayne Walker 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....


-- 

Wayne Walker

www.broadq.com :)  Bringing digital video and audio to the living room



More information about the Austin mailing list