DBD::Proxy & Setting DBH attributes.

From: Scott T. Hildreth (shildret_at_scotth.emsphone.com)
Date: 07/20/04 

To: "dbi-users@perl.org" <dbi-users@perl.org>
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

Relevant Pages

  • Re: searching for missing element in an array
    ... What happens if the array was initialized to all -1 values? ... we know that a zero is stored in the slot of the missing number? ... initialization of the array. ... there are n-1 numbers present. ...
    (comp.programming)
  • Re: question about max_readahead for ide devices in 2.4?
    ... Andrew> That's correct - it's all a bit weird. ... sets an entry in the read_aheadarray. ... Or am I missing something else?? ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • Re: array Puzzle (spoiler)
    ... >) The key is that the integers in the input array are sequential, ... > So now you know one value, and the sum of the two others. ... some of the missing values is generally applicable. ... None of these ranges can contain *all* of the missing values, ...
    (comp.programming)
  • Re: searching for missing element in an array
    ... "Suppose we have n numbersand there is an array of size ... which number is missing from the array if ... there are n-1 numbers present. ... which is implied by the phrase "which number is missing" ...
    (comp.programming)
  • Re: How to count skipped numbers?
    ... numbers somewhere (array, table, other file)? ... Use a quick query to count the number of missing records for you, ... INTO tblCountOfMissingRecs ... consecutive integers in an autonumber field. ...
    (comp.databases.ms-access)