Tried sending this yesterday, and it never showed up on the list.
Trying again...
-----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)?
>
> Thanks,
>
> STH
