Hello,
As far as I know, fetchrow_hashref() return a hashref
with colum_name as keys.
My question is:
Is there a way to say to fetchrow_hashref() to return a hashref
where keys will contain both table_name and colum_name ?
I know that I can use aliases in my sql statement like this :
$sql=" select
table1.col1 as table1.col1,
table2.col2 as table2.col2
from
table1,
table2
where tabe1.id=table2.id";
But, I don't want typing thousand times "as" while building the sql,
if have a lot of field to select.
I need my sql to be something like
$sql=" select
table1.*,
table2.col2
from
table1,
table2
where tabe1.id=table2.id";
And the fetchrow_hashref should concantenate(separated by dot or something else)
table_name and column_name as key of its returned href.
Thanks in advance for your help.
Jos�.
**** DISCLAIMER ****
"This e-mail and any attachment thereto may contain information which is confidential
and/or protected by intellectual property rights and are intended for the sole use of
the recipient(s) named above.
Any use of the information contained herein (including, but not limited to, total or
partial reproduction, communication or distribution in any form) by other persons than
the designated recipient(s) is prohibited.
If you have received this e-mail in error, please notify the sender either by
telephone or by e-mail and delete the material from any computer".
Thank you for your cooperation.
For further information about Proximus mobile phone services please see our website at
http://www.proximus.be or refer to any Proximus agent.
