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