good chemistry is complicated, and a little bit messy -LW |
|
PerlMonks |
DBI, mysql, SELECT with JOIN and field namesby submersible_toaster (Chaplain) |
on Feb 14, 2005 at 06:52 UTC ( [id://430707]=perlquestion: print w/replies, xml ) | Need Help?? |
submersible_toaster has asked for the wisdom of the Perl Monks concerning the following question: Mellow Fonks, For instance, $sth->fetchall_arrayref({}) is something I have learned to love, except when returning results from joined tables where field names from different tables collide, clobbering keys in the hash. Apart from using AS in my SELECT statements, how can I convince DBI to return full table.column type field names. I thought that $dbh->{FetchHashKeyName} = might be my answer but it would seem not. For example purposes only:
Update:on Feb 14, 2005 at 21:36 GMT-10
I can't believe it's not psellchecked
Back to
Seekers of Perl Wisdom
|
|