[Fwd: DBD::Proxy & Setting DBH attributes.]
From: Scott T. Hildreth (shildret_at_scotth.emsphone.com)
Date: 07/21/04
- Previous message: Scott T. Hildreth: "DBD::Proxy & Setting DBH attributes."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: "dbi-users@perl.org" <dbi-users@perl.org> Date: Wed, 21 Jul 2004 08:10:49 -0500
Tried sending this yesterday, and it never showed up on the list.
Trying again...
-----Forwarded Message-----
> From: Scott T. Hildreth <shildret@scotth.emsphone.com>
> To: dbi-users@perl.org <dbi-users@perl.org>
> 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
- Previous message: Scott T. Hildreth: "DBD::Proxy & Setting DBH attributes."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]