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

2001-09-07 Thread Dana Powers
-- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> 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, Phil

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 b

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