On Mon 03 Mar 2003 18:33, Tim Bunce <[EMAIL PROTECTED]> wrote:
> Specifically, which DBD's include the table name in {NAME}?
> In other words, what does:
>
> $sth = $dbh->prepare("SELECT table.field FROM table"); # note table.field
> $sth->execute;
> print "NAME_lc = '$sth->{NAME_lc}->[0]' \n";
>
> for the drivers you use?
>
> Is it 'field' or 'table.field'?
I've written DBD::Unify to return 'field'
FWIW IMHO NAME_lc should be the default. If you realy want uppercase names,
use NAME_uc, but you all know my dislike of the `features' of Oracle :)
--
H.Merijn Brand Amsterdam Perl Mongers (http://amsterdam.pm.org/)
using perl-5.6.1, 5.8.0 & 633 on HP-UX 10.20 & 11.00, AIX 4.2, AIX 4.3,
WinNT 4, Win2K pro & WinCE 2.11 often with Tk800.024 &/| DBD-Unify
ftp://ftp.funet.fi/pub/languages/perl/CPAN/authors/id/H/HM/HMBRAND/
