[Fwd: DBD::Proxy & Setting DBH attributes.]

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

  • Next message: Thomas Mieslinger: "Re: dbi-dbd on solaris w/installed perl"
    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


  • Next message: Thomas Mieslinger: "Re: dbi-dbd on solaris w/installed perl"