APM: DBI "bug"

Wayne Walker wwalker at broadq.com
Sun Sep 14 20:27:50 CDT 2003


I've since found a reference in the man page that specifies that this
works as I describe and I just have to live with it.   :(

On Sun, Sep 14, 2003 at 08:16:37PM -0500, Wayne Walker wrote:
> 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
> _______________________________________________
> Austin mailing list
> Austin at mail.pm.org
> http://mail.pm.org/mailman/listinfo/austin

-- 

Wayne Walker

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



More information about the Austin mailing list