Perl DBI: Same column name in different tables problem

2001-09-07 Thread Philip Mak
Let's say I performed the following query using Perl DBI: $row = $dbh-selectrow_hashref(~); SELECT fanfics.handle, authors.handle FROM fanfics, authors WHERE fanfics.aid = authors.aid ~ I won't be able to access both fanfics.handle and authors.handle this way, because they're called handle. I

Re: Perl DBI: Same column name in different tables problem

2001-09-07 Thread Jeremy Zawodny
On Fri, Sep 07, 2001 at 10:03:03PM -0700, Philip Mak wrote: Let's say I performed the following query using Perl DBI: $row = $dbh-selectrow_hashref(~); SELECT fanfics.handle, authors.handle FROM fanfics, authors WHERE fanfics.aid = authors.aid ~ I won't be able to access both

Re: Perl DBI: Same column name in different tables problem

2001-09-07 Thread Dana Powers
] To: Philip Mak [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, September 07, 2001 10:48 PM Subject: Re: Perl DBI: Same column name in different tables problem On Fri, Sep 07, 2001 at 10:03:03PM -0700, Philip Mak wrote: Let's say I performed the following query using Perl DBI: $row