perl 5.8
DBI, DBD::Proxy 1.21
DBD::Proxy 1.48
linux RedHat 2.4.21

Hello,

I am looking for the answer to the problem that was sent to the dbi-users a few
months ago:


-----Forwarded Message-----
> From: Scott T. Hildreth <[EMAIL PROTECTED]>
> To: [email protected] <[email protected]>
> Subject: DBD::Proxy & Setting DBH attributes.
> Date: Tue, 20 Jul 2004 16:39:21 -0500
> 
> I am asking a question, that I'm pretty sure I know the answer to, but
> just in case I am missing something, 
> 
> The following example code works,
> 
> use DBI;
> 
> my $dbh = DBI->connect('dbi:Oracle:sid', 'user', 'password', {});
> 
> $dbh->{FetchHashKeyName} = 'NAME_lc';
> 
> my $res = $dbh->selectall_hashref(q{
>               Select id, name, sum 
>               From   foo 
>           }, 'id');
> 
> ...if I use DBD::PROXY the setting of 'FetchHashKeyName' does not work.
> 
> I did see this in DBD::Proxy perldocs,
> 
> KNOWN ISSUES
>        Complex handle attributes
> 
>        Sometimes handles are having complex attributes like hash refs or
> array
>        refs and not simple strings or integers. For example, with
> DBD::CSV,
>        you would like to write something like
> 
>          $dbh->{"csv_tables"}->{"passwd"} =
>                { "sep_char" => ":", "eol" => "\n";
> 
> 
> ...but I did not think that FetchHashKeyName is a complex attribute..
> 
> Am I missing something(probably)?  
---------------------------

I have a similar problem. Can anybody find a solution?

Thank you for your patience.
Wojciech Pietron

Reply via email to